Count if

  • Thread starter Thread starter Bob
  • Start date Start date
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.
 
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)
 
You must log in or register to reply here.

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

counting records 0
Count Only Yes checks in Access Report 1
Need help: table with all locations AND just one location 1
Counting Records in a Report 8
Access Dcount (multiple criteria) 3
Expression in Access "Reports" 2
Count funtion in report-I'm too rusty! 1
Count Reports Sent Before A Specific Time 4

Back
Top