Vendor Count Report, Please Help!

[pfm721]

The scenario is that I need to count the number of patients that we have
sourced out to different vendors.

tblTracker
Vet
Location

tblVendor
Location

basically all I want to see on the report is the Location listed one time,
with the number of patients that have gone to that vendor. I know I need to
use the count function in the query I am just not sure how to set this up
because I have never done it.

 

[Maverick]

I don't see the need for a query unless you are limiting the data in some
way. What you need to do is create a group in Design View. Choose to group by
vendor. One of the options for the group is to do a calculation. Choose to do
a count. That should do it.