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

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

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

Ian

Fornatian,
Thanks for your help as always.

BAC

Disseminate to Accumulate...