Question on counting records in Access

[Guest]

I have used the "yes/no" option in a table. I generated a report from the
table using an open query. I want to count all records that have been checked
or "True" and exclued counting records that have not been checked. Can anyone
help?

 

[Joan Wild]

Add these columns to your query
Yes: -Sum([YourField])
No: Sum([YourField]+1)

 

[fredg]

I have used the "yes/no" option in a table. I generated a report from the
table using an open query. I want to count all records that have been checked
or "True" and exclued counting records that have not been checked. Can anyone
help?

Count the records in the Report?
=Abs(Sum([CheckBoxField]))