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

[Guest]

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?

 

[Rick Brandt]

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?

Sum(Abs([Correct Choice]))

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

 

[Guest]

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

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?

Sum(Abs([Correct Choice]))

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