Summing Problem

[scott04]

I am trying to count the number of Yes and No responces from one of my fields
called Fraud_activity. When I run the query there are 3 records. For this
field there are 2 No's and 1 Yes.
I am using a textbox with the formula: =(Sum(Abs([Fraud_Activity])="0")) to
try and obtain the No's. When i run the report i am getting -2 instead of 2.
Any suggestions? Also if i use the formula
=(Sum(Abs([Fraud_Activity])="1")) I received a -1. Any help or suggestions
is appreciated!

 

[scott04]

I have used =Abs(Sum([Fraud_Activity])) and this only gets me the number of
times Yes. How do I get the number of times "no"?

 

[scott04]

Nevermind everyone i figured it out
=Sum([Fraud_Activity]+1)

I have used =Abs(Sum([Fraud_Activity])) and this only gets me the number of
times Yes. How do I get the number of times "no"?

I am trying to count the number of Yes and No responces from one of my fields
called Fraud_activity. When I run the query there are 3 records. For this
field there are 2 No's and 1 Yes.
I am using a textbox with the formula: =(Sum(Abs([Fraud_Activity])="0")) to
try and obtain the No's. When i run the report i am getting -2 instead of 2.
Any suggestions? Also if i use the formula
=(Sum(Abs([Fraud_Activity])="1")) I received a -1. Any help or suggestions
is appreciated!

 

[scott04]

Nevermind everyone i figured it out
=Sum([Fraud_Activity]+1)

I have used =Abs(Sum([Fraud_Activity])) and this only gets me the number of
times Yes. How do I get the number of times "no"?

I am trying to count the number of Yes and No responces from one of my fields
called Fraud_activity. When I run the query there are 3 records. For this
field there are 2 No's and 1 Yes.
I am using a textbox with the formula: =(Sum(Abs([Fraud_Activity])="0")) to
try and obtain the No's. When i run the report i am getting -2 instead of 2.
Any suggestions? Also if i use the formula
=(Sum(Abs([Fraud_Activity])="1")) I received a -1. Any help or suggestions
is appreciated!

 

[Marshall Barton]

I am trying to count the number of Yes and No responces from one of my fields
called Fraud_activity. When I run the query there are 3 records. For this
field there are 2 No's and 1 Yes.
I am using a textbox with the formula: =(Sum(Abs([Fraud_Activity])="0")) to
try and obtain the No's. When i run the report i am getting -2 instead of 2.
Any suggestions? Also if i use the formula
=(Sum(Abs([Fraud_Activity])="1")) I received a -1. Any help or suggestions
is appreciated!

=Sum(Abs(Not [Fraud_Activity]))

=Sum(Abs([Fraud_Activity]))