Summing Problem

  • Thread starter Thread starter scott04
  • Start date Start date
S

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!
 
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"?
 
Nevermind everyone i figured it out
=Sum([Fraud_Activity]+1)

scott04 said:
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 said:
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!
Click to expand...
Click to expand...
 
Nevermind everyone i figured it out
=Sum([Fraud_Activity]+1)

scott04 said:
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 said:
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!
Click to expand...
Click to expand...
 
scott04 said:
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!
Click to expand...


=Sum(Abs(Not [Fraud_Activity]))

=Sum(Abs([Fraud_Activity]))
 
Back
Top