How to add up check boxes [morning]

[soojosie]

Am doing a simple database where there are a no. of check boxes 1-20, each person can select several on each visit.
I would like to run a report from a query that can add up how many/who ticked 1, 2, 3 and/or 4, so I have a total for 1, 2 etc, these will be per date blocks.
The “who” is not necessary, tho it would be nice, but I can’t add the check boxes and that’s a drama.
When trying to add them reports keep showing YES or NO not the totals!
What am I doing wrong?

 

[nat1967]

Hiya,

Try a query like this:

SELECT Sum(IIf(cboCheck=-1,1,0)) AS TotalCheckBox
From tblTestCheckBox

Since checkboxes are a Yes/No or True/False, you have to count the ones that have a certain value.

HTH

Have A Great Day!!!,

Nathan
Senior Test Lead