Count function returns nothing

[Sandra]

I have a large count query that if there are rows for all
the criteria being counted, it works. However, if only
one criteria has no rows, the entire query returns
nothing. How can I get around this?
Sandra

 

[Gerald Stanley]

If you want a row to be counted only when all the criteria
are met, use AND to join the criteria. If you want a row
to be counted when at least one of the criteria is met use
OR to join the criteria.

Hope This Helps
Gerald Stanley MCSD