Count 0 values in query

[Hayley Baxter]

Hello Board

I'm not having a good day I can assure you, can't work anything out on my own today think I should go home!

I have a totals query which I have criteria as count(*) to return a count of all records, however I also want the 0 values returned. I have been informed I need to look at the NZ function but where does this fit into my current query?

Cheers
Hay

 

[Dona]

In your table add a Count field. Put a 1 for all your records.
Add this field to your query. Now you should be able to count your null fields.

I hope this helps.