Microsoft Office Tutorials and References
In Depth Information
Session 3.1
Selecting two sort fields in Design view
Figure 3-16
sort order for the
primary sort field
sort order for the
secondary sort field
You have finished your query changes, so now you can run the query and then save the
modified query with the same query name.
8. Click the Run button on the Query Design toolbar. Access runs the query and displays
the query datasheet. The records appear in ascending order, based on the values of the
PositionTitle field. Within groups of records with the same PositionTitle field value, the
records appear in descending order by the values of the Openings field. See Figure 3-17.
Datasheet sorted on two fields
Figure 3-17
primary
sort field
secondary
sort field
records shown
in descending
order by
Openings
 
Search JabSto ::




Custom Search