Counting Check Boxes

B

Bob

I am working on a query, in which previously on a form, the user checks a box
to indicate if Air transportation was provided or not. Now in this query I
need to have a tally of the number of checked boxes from this category, what
expression would I use in the Expression builder?
 
F

fredg

I am working on a query, in which previously on a form, the user checks a box
to indicate if Air transportation was provided or not. Now in this query I
need to have a tally of the number of checked boxes from this category, what
expression would I use in the Expression builder?
Click to expand...

Create a new column.
CountOfYes:Abs(Sum([CheckBoxField]))
 
Top