Count ticks in checkboxs

[Dr_Worm]

Hi,

I need to count all records with a tick in their "Supervisor" checkbox, the total is to be displayed on a report. I've tried to use DCOUNT but can't get it to work.

Do I need to count on the report, or within the query grid, or SQL?

 

[SydneyGeek]

If the "Supervisor" checkbox is linked to a field, all YES values will be -1, and all NO values will be zero.

By creating a textbox with the expression
=-SUM([Supervisor]) {Note: adjust field name}
and placing that on a section header / footer, you'll get totals for all supervisors in each group. Place the same textbox on a Report Header / Footer to get the total for the whole report.

Denis