counting yes/no boxes

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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
 
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]))
 
Back
Top