Tutorial

Lesson 3
|
Finding and sorting records 27
Sort your found set
After you have a found set of records to work with, you might want to sort those records. For example, you
might want to display the records in alphabetical order, or sort them from newest to oldest.
To sort records in alphabetical order by the members’ last names:
1. In the layout bar, click the Layout pop-up menu and choose Club List.
The Club List layout appears.This layout will make it easier to see the results of the sorting. The black
bar to the left of the record for Mary Smith indicates it is the current record in the found set.
2. Click Sort in the status toolbar.
The Sort Records dialog box appears.
3. If any fields appear in the Sort Order column on the right side of the dialog box, click Clear All.
4. In the list of available fields on the left, select Last Name and click Move.
Notice the sort direction symbol to the right of the Last Name field increases in size from left to right. This
indicates that when the database is sorted by this field, the data will be in ascending order (from a to z).
5. Click Sort.
The names in the Club List are now displayed in alphabetical order by last name. Notice that the current
record is still Mary Smith, and this record has moved to its sorted location in the list.
Choose Club List
Current record
Sort direction buttons
become active when a
field is selected