Home > Sample chapters > Microsoft Office > Access

Selecting Data Using Queries in Microsoft Access 2013

Returning the top matched records

If you order a set of results with a query, you might be interested in only a limited number of records—for example, the top five records, or the top 10% of records. A query has a Top Values property to give you control over the number of records being displayed.

Return the top matched records

  1. Sort your data.

  2. Click to select the number of records to show. You can enter values other than those shown in the list—for example, the top 3 records instead of the top 5.