Count function returns nothing

  • Thread starter Thread starter Sandra
  • Start date Start date
S

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
 
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
 
Back
Top