Help with Breakdown of Info

[tanyalee123]

Sorry, I can't figure out what the term or query type this would be. I have a table of providers and I need a breakdown by zip code. So I need to create a query that will just show totals of doctors in all of the different zip codes. I will have to extract this from a couple of different tables, but I think I'll be okay there doing an inner join. I'm just not sure what the criteria of my query would be...



Thank you for your assistance!

Tanya

[JoeM]

If you want a summary of the different zip codes and the number of doctors in each zip code, you will want to use an Aggregate (Totals) Query, where you "Group by" Zip Code and "Count" the doctors.
Check out "Aggregate (or Totals) Query" in Access built-in help file, or on-line with a Google Search. Its pretty easy and there are lots of details and examples out there.

[tanyalee123]

That's the word I couldn't think of! I'm not a math person at all lol
Thank you so much!