Counting Yes No Fields

[pwilson]

I have several yes/no fields and need a count of the ones coded yes. It is counting all coded yes and no. Any ideas!!

[jwreding]

Add another column to your query for the yes/no field, and enter "True" for the criteria. In the Total section, choose Where.

[pwilson]

Add another column to your query for the yes/no field, and enter "True" for the criteria. In the Total section, choose Where.

I am able to get this to work if I need a total on just 1 yes/no field. It is not counting correctly if I put more than 1 yes/no field. I do have other criteria like audit name and audit date, plus 12 yes/no fields.

[dblife]

Have you tried simply adding them up in a final column but ensure all the original fields have had the Nz() function used on them to cope with nulls - I read somewhere the problem with yes/no boxes is they are difficult to deal with nulls with.
Most serious access users use them very sparingly.
Maybe there is a better way to get your results than using checkboxes?