Microsoft Office Tutorials and References
In Depth Information
3
Click Yes and then close the Query
Properties sheet by clicking its
Close button.
View
button
View the query results
(Figure 2–40).
query
results
each city listed
only once
Other Ways
1. Right-click second fi eld
in design grid, click
Properties on
shortcut menu
Figure 2–40
To Sort on Multiple Keys
The following steps sort on multiple keys. Specifi cally, the data is to be sorted by amount paid (low to high)
within recruiter number, which means that the Recruiter Number fi eld is the major key and the Amount Paid fi eld is
the minor key.
1
Return to Design view.
Clear the design grid.
Include the Client Number, Client
Name, Recruiter Number, and
Amount Paid fi elds in the query in
this order.
View
button
Select Ascending as the sort order
for both the Recruiter Number
fi eld and the Amount Paid fi eld
(Figure 2–41).
Amount
Paid fi eld
of the two sort keys,
Recruiter Number
fi eld will be major key
because it is on the left
Recruiter
Number fi eld
Ascending
sort order
Figure 2–41
 
Search JabSto ::




Custom Search