counting yes/no boxes

[Ryan]

trying to count the number of yes/no boxes checked in a
query but cannot figure out how to set up my control..

used the count(*) to count the records

can count the number of times something appears in a text
field but cannot figure out how to count the number of
time a check box has been checked....

help please..

Ryan

 

[Ken Snell]

True is -1, False is 0.

So, Sum(-[CheckBoxField]) will give you the count of the checkboxes that are
checked true.
Or Abs(Sum[CheckBoxField]))