yes/no

Paola · Sep 2, 2003

how do i count how many yes or no i have in a query? the
info is coming from a table that has a yes/no check box
field.
any info is appreciated

Fredg · Sep 2, 2003

Paola,
To count Yes:
CountYes:Abs(Sum([CheckBoxField]))

To Count No:
CountNo:Sum(IIf([CheckBoxField]=0,1,0))
Or..
CountNo:Sum([Check]+1)