HOW CAN I GET TOP30 RECORDS IN ACCESS QUERY

D

David

I have sorted values in Access Query, the sorted query contains more than 150
records, how can i get top30 records only? many thanks!
 
J

John W. Vinson

I have sorted values in Access Query, the sorted query contains more than 150
records, how can i get top30 records only? many thanks!
Click to expand...

Open the query in design view; right click the grey background of the tables,
and select Properties. Set the "Top Values" property to 30.
 
Top