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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare current month totals with last months totals 1
Display columns without data in cross tab query 4
Access Updating inventory levels 0
How to use the same date range parameters for multiple reports 2
Query to Report Glitch 1
Problem with group by query over date range 1
How do I query a calculated control? 1
Use of Max is quite working 3

Back
Top