Microsoft Office Tutorials and References
In Depth Information
View the query results
(Figure 2–42).
Return to Design view and try
other sort combinations for the
Recruiter Number and Amount
Paid fi 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 fi nished, select
Ascending as the sort order for
both fi elds.
What if the Amount Paid fi 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 fi eld to the left of
the Recruiter Number fi eld, your
results would be incorrect.
within group of clients
with the same recruiter
number, rows are
sorted by amount paid
overall order
is by recruiter
Figure 2–42
To Create a Top-Values Query
Rather than show all the results of a query, you may want to show only a specifi 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,
fi 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 fi rst
fi 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.
box arrow
Design tab
Return box
Click the Return box arrow on the
Design tab to display the Return
box menu (Figure 2–43).
fi rst fi ve
display fi rst 5%
of records
box menu
display all
Figure 2–43
Search JabSto ::

Custom Search