Query to count check boxes

[rzkl]

I have a query problem that I have had no luck solving either through books or other post on this fourm. It might be because of my lack of Access skills or just might not be possible. I have a query that looks at one field in a table to count how many records have the check box checked. It works great when the query can find at least one as it reports it back, but when there are none with the boxes checked it comes back blank. What I really need it for when there are no records checked for it to come back with a 0. I have tried using NZ with no luck. If anyone has a solution to this either using NZ or some other way please let me know. Also please explain in beginner terms as Im still learning.

Thanks in advance

 

[Mile-O]

You can use DCount().