Count if

B

Bob

In my table I have a yes/no field and I want to send it
to a report and count how many yes's or no's in the report.
Is there a count if type function in building a report
like this.
 
D

Duane Hookom

Yes/No fields store values of -1/yes or 0/no so you can just sum the field
and find the absolute value
=Abs(Sum([YesNoField]))
or sum the No values
=Sum(YesNoField + 1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Yes/No field in report? 2
counting records 0
Excel Count from last specific text 3
Summing Problem 4
Count Check boxes and create short report 10
Count Only Yes checks in Access Report 1
Need help: table with all locations AND just one location 1
Counting checkbox No's 5

Top