One of the most common querying tasks is finding the most or least of something. For example, you may need to know who had the most sales last quarter, or which student has the lowest grades. You can do that with a top-values query. You can also retrieve a specific number of records, such as your 10 best sellers, or a percentage of records, such as the students in the bottom 25 percent of the class.
Open your query in Design view. To do that, go to the Navigation Pane, and under Queries
, right-click the query and click Design View
On the Design
tab, in the Query Setup
group, open the Return
list and select a value, or enter a value of your own. You can enter numbers or percentages.
In the design grid, click the Sort
row, open the list, and select a sort order. The sort order tells the query to return either the top or bottom values. To see low values, such as the bottom 25 percent of monthly sales, sort in Ascending order
. To see high values, sort in Descending Order
. If that seems a bit confusing, it will make more sense during the practice.
Test your changes. On the Design
tab, in the Results
group, click Run
Next, let's go deeper into selection criteria.