counting problem???

[PQTIII]

How do I count all records that have a zero value for a particular field?

Thanks
pt

 

[ZmrAbdulla]

Try "DCount() Function". Have a search in the VBA help file.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Education's purpose is to replace an empty mind with an open one.
~Malcolm S. Forbes~

 

[mp9]

Or, if using a query:

SELECT Count(*) AS TotalOfZeros
FROM TableNameHere
WHERE FieldNameHere=0;

Don't forget to consider how to treat nulls.