Count Yes/No Field

[bill crumpton]

I have a check box (yes/no) on a form that I have included in a query. I would like to count the check box and display how many times the check box is checked and display this info on a report. Any help is greatly appreciated. Thanks.

BAC

 

[Fornatian]

FOR TICKED BOXES
Sum(IIf(Me![MyCheckBox]=True,1,0))

FOR UNTICKED BOXES
Sum(IIf(Me![MyCheckBox]=False,1,0))

Ian

 

[bill crumpton]

Fornatian,
Thanks for your help as always.

BAC

 

[Fornatian]

Disseminate to Accumulate...