Quick Start

44 Getting Started Guide
7. In the status area, click the Symbols pop-up menu and select range
from the list.
8. After the ellipsis, type 2/29/2000 in the Date Paid field.
9. Click Omit in the status area to select it.
10. Click Find.
Your search returns five records for five members who paid their fees
within the first six months of 2000, except the month of February.
Sort your found set
Once 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. Go to the layout pop-up menu and choose the List of Members
layout. This layout will make it easier to see the results of the sorting.
2. Choose Records menu > Sort.
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, 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 List of Members are now in alphabetical order by
last name.
6. When you are finished with this lesson, close each open file by
choosing File menu > Close.
For more information
You have found records based on a variety of criteria, and narrowed
your searches by using Omit. You have sorted the results of your
searches. For more information on finding and sorting records in
FileMaker Pro, see chapter 3 of the FileMaker Pro User’s Guide.
Omit checkbox
Sort direction
buttons become
active when a
field is selected