criteria expression to return top 50 records.

[Utracman]

Easy one

What criteria expression would return the top 50 records.

Example

A field has [lastMonthRev] which is the amount the client billed last month. I need to build a query for a report that will return the top clients based on [lastMonthRev].

Many thanks!

Dave To learn fron those who have mastered the art..... Saves many headaches!

 

[villica]

Under design view of the query If you right click , properties, on the line top values type 50.

 

[Utracman]

Thanks!

Dave To learn fron those who have mastered the art..... Saves many headaches!