Top 20

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

Guest

I hv thousand of record as per sample below

Cust Amount StateCode
A 1000 123
B 2000 124

and so on

Q,

How to create a query or report that will display TOP 20 cust who has the
largest amount.....

TQ
 
Use the properties of the query to specify "Top Values".

Use sort criteria in the field you wish to name the Top "x" values. Enter
the integer of the number of top values you want to return in the property
"Top Values" of the query.
 

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

Top 20 Account By Branch 24
Calculate Null Field 2
To Include All Data 21
Query for earliest due date 5
Top 50% Grouped by Month 3
Top 20 1
Supress rows in report 2
Calculated Fields 3

Back
Top