Query Parameters (1 Viewer)

[GreenshootProgrammer]

I have an invoice query that has a lot of fields, I want to create a copy of the query that searches for the best paying customer. How would I add up all the costs per customer and find out which one is the most?

 

[pbaldy]

You want a totals query along the lines of:

SELECT Customer, Sum(Amount)
FROM TableName
GROUP BY Customer
ORDER BY Sum(Amount) DESC

 

[GreenshootProgrammer]

You want a totals query along the lines of:

SELECT Customer, Sum(Amount)
FROM TableName
GROUP BY Customer
ORDER BY Sum(Amount) DESC

I know about totals in queries but I'm a bit confused about your instructions.

 

[pbaldy]

If you know about them, create one with those 2 fields, grouping on the customer and summing the amount, and put a sort on the amount field.