Max Function on Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a field for customers, transaction amt and product in my query.The
select query retrieves the records fine and i have added the sum function for
transaction amt and the count for each transaction of each product.How can i
order the customers which have the most transactions first?This is for
report purposes since i will be using the customers as a grouping level with
the most transactions appearing in order from the most to least.
 
Back
Top