D David Sep 18, 2009 #1 I have sorted values in Access Query, the sorted query contains more than 150 records, how can i get top30 records only? many thanks!
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 Sep 18, 2009 #3 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.
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.
