yes/no

[Paola]

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]

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

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