Y/N field in a query. How do I get report Summary to count Ys?

M

MaxPower

I am building a report based on a query. One of the fields in the query is a
"Yes/No" field. I am working in the report footer to try to get a count of
all records where that field is "YES". A "COUNTIF" would be perfect, but
I am not having any luck.

Let's say the field name is "Correct Choice". How can I get the total # of
correct choices to display in the Report Footer?
 
R

Rick Brandt

MaxPower said:
I am building a report based on a query. One of the fields in the
query is a "Yes/No" field. I am working in the report footer to try
to get a count of all records where that field is "YES". A
"COUNTIF" would be perfect, but I am not having any luck.

Let's say the field name is "Correct Choice". How can I get the
total # of correct choices to display in the Report Footer?
Click to expand...

Sum(Abs([Correct Choice]))

This works because True (or Yes) is stored as negative one while False is
stored as zero.
 
M

MaxPower

Rick.... you are a LIFE SAVER!!!!!!!

Rick Brandt said:
MaxPower said:
I am building a report based on a query. One of the fields in the
query is a "Yes/No" field. I am working in the report footer to try
to get a count of all records where that field is "YES". A
"COUNTIF" would be perfect, but I am not having any luck.

Let's say the field name is "Correct Choice". How can I get the
total # of correct choices to display in the Report Footer?
Click to expand...

Sum(Abs([Correct Choice]))

This works because True (or Yes) is stored as negative one while False is
stored as zero.
Click to expand...
 
Top