Showing zeros in a count

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a query set up to count totals of visits for
different hospitals within a given time frame. I want it
to list all hospitals regardless of if they had any visits
or not showing me a "0". Can this be done?

Thanks,
Amy
 
Change your criteia for your query so that all records from the table
containing the hospitals pull. You most likely need to change the "Join".

Give us more details on how the query is built if you are unable to get it
working from this post.

Rick B


I have a query set up to count totals of visits for
different hospitals within a given time frame. I want it
to list all hospitals regardless of if they had any visits
or not showing me a "0". Can this be done?

Thanks,
Amy
 
Back
Top