Vendor Count Report, Please Help!

  • Thread starter Thread starter pfm721
  • Start date Start date
P

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