how to write a query to display sum

S

stacie

I have a table with vendors, patients ,total amount paid. I want to wirte a
query which will list the name of the vendor, count the number of times the
patient's ssn appears with that vendor, and the total amout paid to that
vendor by the patient.
 
R

Ryan

Not to hard. Just create a queary with all three columns, Vendors, and
Patients and total amount paid. Once open right click next to one of the
fields, and then click Totals. This will add a totals row to your query.
Leave Vendors and Patients totals set to Grouping, and change total amount
paid to sum. That should do the trick.
 
Top