Selecting Data Using Queries in Microsoft Access 2013
- Selecting all columns from a table
- Selecting individual columns from one or more tables
- Joining tables to see unmatched or missing records
- Filtering by single and multiple combinations of choices
- Adding calculations with the expression builder
- Returning the top matched records
- Eliminating duplicate values
- Creating a summary calculation
- Prompting to filter data with parameters
- Creating a crosstab query with the Query Wizard
- Simplifying a problem with a query by using other queries
- Adding two sets of query results together
- Resolving ambiguous outer joins
- Creating an additional query to resolve a problem with mixed joins
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
Sort your data.
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.