10 Best Customers!

[drive.hard-go.pro]

I want to make a report that will display the 10 best customers accordingly to their purchases! In my customers table i have a total purchases field that show the amount of purchases the customer has.... Anyone can help me with this ?



Thank you

 

[wazz]

Top 10
- there's a combobox at the top of the query design grid (Top Values) that probably says "All". type 10 into it and you'll get 10 results.

 

[drive.hard-go.pro]

thank you...