Microsoft Office Tutorials and References
In Depth Information
• View the query results
• Return to Design view and try
other sort combinations for the
Recruiter Number and Amount
Paid ﬁ elds, such as Ascending for
Recruiter Number and Descending
for Amount Paid. In each case, view
the results to see the effect of the
changes. When ﬁ nished, select
Ascending as the sort order for
both ﬁ elds.
What if the Amount Paid ﬁ eld is to
the left of the Recruiter Number?
It is important to remember that
the major sort key must appear to
the left of the minor sort key in
the design grid. If you attempted
to sort by amount paid within
recruiter number, but placed the
Amount Paid ﬁ eld to the left of
the Recruiter Number ﬁ eld, your
results would be incorrect.
within group of clients
with the same recruiter
number, rows are
sorted by amount paid
is by recruiter
To Create a Top-Values Query
Rather than show all the results of a query, you may want to show only a speciﬁ ed number of records or a
percentage of records. Creating a top-values query allows you to quantify the results. When you sort records, you
can limit results to those records having the highest (descending sort) or lowest (ascending sort) values. To do so,
ﬁ rst create a query that sorts the data in the desired order. Next, use the Return box on the Design tab to change the
number of records to be included from All to the desired number or percentage. The following steps show the ﬁ rst
ﬁ ve records that were included in the results of the previous query.
• Return to Design view.
• If necessary, click Design on the
Ribbon to display the Design tab.
• Click the Return box arrow on the
Design tab to display the Return
box menu (Figure 2–43).
ﬁ rst ﬁ ve
display ﬁ rst 5%