Counting Check Boxes

B

Boz

I have a form that uses a number of check boxes for certain conditions. I
would like to create a query that counts the number of "Yes" answers for each
field.

Please help

Thanks.
 
J

Jerry Whittle

Yes is stored as -1 and No as 0. Therefore the following will work for
counting up all the yesses in a Totals query..

Yeps1: ABS(Sum(YourYesField1))
 
Top