Top 20

[zyus]

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

 

[Jeff C]

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.