Negative numbers and percentages

I have a form that populates a report with a number of respondents and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and true =
-1. That's valid, no problem. But when you come up with your sum, such as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

I copied that into the Control Source so that my Control Source now read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with my
other Control Source (SumOfQ1good). Is there something else I need to try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and true =
-1. That's valid, no problem. But when you come up with your sum, such as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with my
other Control Source (SumOfQ1good). Is there something else I need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and
true =
-1. That's valid, no problem. But when you come up with your sum, such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with my
other Control Source (SumOfQ1good). Is there something else I need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and
true =
-1. That's valid, no problem. But when you come up with your sum, such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

Use the ABS function on it. Abs is the ABSolute function which strips off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number

"Anita" wrote in message
...
John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now
read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with
my
other Control Source (SumOfQ1good). Is there something else I need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and
true =
-1. That's valid, no problem. But when you come up with your sum, such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents
and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers
that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

It strips the negative sign, but now it asks me to enter a parameter value.
--
Anita


"John Spencer" wrote:

Use the ABS function on it. Abs is the ABSolute function which strips off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number

"Anita" wrote in message
...
John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now
read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with
my
other Control Source (SumOfQ1good). Is there something else I need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and
true =
-1. That's valid, no problem. But when you come up with your sum, such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents
and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers
that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

John,

I've tried entering:

Abs(SumOfQ1Good)

This takes the negative away, but it then asks for a Parameter Value. I've
even tried to copy the other Control Sources which have the same exact
wording except for the 'good' (it's either 'excellent', 'fair' or 'poor') and
it's fine. It's just this Control Source.

Any other suggestions?

Thanks and have a great weekend!
--
Anita :-)


"Anita" wrote:

It strips the negative sign, but now it asks me to enter a parameter value.
--
Anita


"John Spencer" wrote:

Use the ABS function on it. Abs is the ABSolute function which strips off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number

"Anita" wrote in message
...
John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now
read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it with
my
other Control Source (SumOfQ1good). Is there something else I need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false = 0 and
true =
-1. That's valid, no problem. But when you come up with your sum, such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of respondents
and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3 people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the numbers
that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

I'm not seeing what could cause the problem.

Make sure your control is not named SumOfQ1Good
Make sure you have an equals sign before Abs(SumOfQ1Good)
Make sure you haven't misspelled SumOfQ1Good --- This is most often the
cause of a parameter prompt appearing. Often it will be a space within the
name. That is sometimes very difficult for my old eyes to see.

"Anita" wrote in message
...
John,

I've tried entering:

Abs(SumOfQ1Good)

This takes the negative away, but it then asks for a Parameter Value.
I've
even tried to copy the other Control Sources which have the same exact
wording except for the 'good' (it's either 'excellent', 'fair' or 'poor')
and
it's fine. It's just this Control Source.

Any other suggestions?

Thanks and have a great weekend!
--
Anita :-)


"Anita" wrote:

It strips the negative sign, but now it asks me to enter a parameter
value.
--
Anita


"John Spencer" wrote:

Use the ABS function on it. Abs is the ABSolute function which strips
off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number

"Anita" wrote in message
...
John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of
respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now
read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it
with
my
other Control Source (SumOfQ1good). Is there something else I
need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false =
0 and
true =
-1. That's valid, no problem. But when you come up with your sum,
such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of
respondents
and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3
people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the
numbers
that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem
to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com

Sigh.... I'm beginning to think these two items are against me....

Now it's giving me 'Error' under both the number of respondents and the
percentage. My control sources a

=Abs([SumOfQ1Good]) - under # of Respondents
=Abs([SumOfQ1Good])/[CountOfRespondentNumber] - under percentage

What should I try next?

Thanks for all of your help with this; I really appreciate it.
--
Anita :-)


"John Spencer" wrote:

I'm not seeing what could cause the problem.

Make sure your control is not named SumOfQ1Good
Make sure you have an equals sign before Abs(SumOfQ1Good)
Make sure you haven't misspelled SumOfQ1Good --- This is most often the
cause of a parameter prompt appearing. Often it will be a space within the
name. That is sometimes very difficult for my old eyes to see.

"Anita" wrote in message
...
John,

I've tried entering:

Abs(SumOfQ1Good)

This takes the negative away, but it then asks for a Parameter Value.
I've
even tried to copy the other Control Sources which have the same exact
wording except for the 'good' (it's either 'excellent', 'fair' or 'poor')
and
it's fine. It's just this Control Source.

Any other suggestions?

Thanks and have a great weekend!
--
Anita :-)


"Anita" wrote:

It strips the negative sign, but now it asks me to enter a parameter
value.
--
Anita


"John Spencer" wrote:

Use the ABS function on it. Abs is the ABSolute function which strips
off
the negative sign. So
Abs(SumOfQ1Good) should return a positive number

"Anita" wrote in message
...
John,

Thanks! That fixed the negative in my percentages.

What do I need to change to fix the negative in my number of
respondents?
The Control Source on that is:

SumOfQ1good

Thanks!
--
Anita


"John Spencer" wrote:

Try

=Abs([SumOfQ1good])/[CountOfRespondentNumber]

Your expression was comparing
[SumOfQ1good] To Abs([SumOfQ1good])/[CountOfRespondentNumber]
and returning false (0) since the two were probably never equal


"Anita" wrote in message
...
I copied that into the Control Source so that my Control Source now
read:

=[SumOfQ1good]=Abs([SumOfQ1good])/[CountOfRespondentNumber]

All it gave me were zeros as my percentage. I didn't even try it
with
my
other Control Source (SumOfQ1good). Is there something else I
need to
try?

Thanks!
--
Anita


"OfficeDev18 via AccessMonster.com" wrote:

Hello, Anita,

Apparently you're adding a Boolean field (yes/no), where false =
0 and
true =
-1. That's valid, no problem. But when you come up with your sum,
such
as -3,
add the following line of code:

SumOfQ1good = Abs(SumOfQ1good)

This returns the absolute value of the variable, and it's always
positive.
Repeat this code for every Boolean field you're adding.

Hope this helps,

Sam

Anita wrote:
I have a form that populates a report with a number of
respondents
and a
percentage (ex. 7 people said 'Excellent' and that's 70%, 3
people
said
'Good' and that is 30%, etc.). The 7, 70, 3 and 30 are the
numbers
that
are
coming out as negatives. The control sources a

For the 3 it's: SumOfQ1good
For the 30% it's: =[SumOfQ1good]/[CountOfRespondentNumber]

I've tried entering the control as
=[SumOfQ1good]/[CountOfRespondentNumber]-1, but it doesn't seem
to be
working.

I also have one line in my report that's not populating at all.

What do I need to do????

Thanks!
Anita :-)

--
Sam

Message posted via http://www.accessmonster.com