Query to add totals 1

[NFLDUser]

I have a query that reads a table to get my payment methods and return the number of purchases by payment type.

But I have also have a field called 'paid' that I would like to get the average totals for each payment type. I'm not sure how to go about this...

SELECT TOP 10 method, Count(*) AS newvar From Billing GROUP BY method ORDER BY 2 DESC

That's what I have...but this is the table I am looking to get.

method newvar avgvalue
-----------------------------------
visa 54 $45
amex 10 $65
cash 10 $95

Ideas?

 

[PHV]

Have you tried this ?
SELECT TOP 10 method, Count(*) AS newvar, CCur(Avg(paid)) AS avgvalue
FROM Billing
GROUP BY method
ORDER BY 2 DESC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NFLDUser]

THANKS!!
Works like a charm.