Count ticked check box

[Bob V]

In my query I want to count the Yes/No in Worksheet, so where do I enter the
0 to find out how many are ticked!..Thanks for any help..Bob
Count: DCount("Worksheet","qryWorksheetActive")

 

[Bob V]

Oops got it, New query with a Like'-1' and then have a count column...Thanks
Bob

 

[Bob V]

How can I Requery my query [qryWorksheetTicked] so as my list box
[lbCountTick] will alter when I de-select my check boxes at the moment I
have to refresh my form............Thanks Bob