If all you care about is the highest or lowest values in a query, you can display only these records. For example, you could display the ten largest or smallest orders in the Invoices table. If you're working with dates, you can display the most recent or oldest results.
- In Design View, select the fields that you want to see in your query.
- Click the appropriate Sort field.
The Sort row works a little differently when you're using Top or Bottom values:
- Ascending: Displays the bottom values.
- Descending: Displays the top values.
Access displays the results of the query.