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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing zero counts 1
No current record error in Access 2000 on Office 2007 machine 3
having trouble making a quiery to the closest date to another date 5
Help needed to create a query 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
CrossTab: Time Block/interval 2
Totalling rows in a query 1
Creating queries asking for counts 6

Back
Top