Quick Start

Finding and sorting records 43
Find records that match a range
of criteria in the same field
Sometimes, you might want to find records that match a range of
criteria within a single field. For example, you might want to find all
of the records that fall within a one-month period, or locate all of the
sales invoices numbered between 500 and 1000.
To perform this type of search in FileMaker Pro, you use a special
range symbol in your find request to specify the lower and upper
limits of your find criteria.
To find the members who paid their membership fees between
January 1, 2000 and June 30, 2000:
1. Choose View menu > Find Mode.
2. Type 1/1/2000 in the Date Paid field.
3. In the status area, click the Symbols pop-up menu. Select range
from the list.
4. Your find request should now have 1/1/2000... in the Date
Paid field. Immediately after the ellipsis (...), type 6/30/2000.
5. Click Find.
Your search returns six records, for six members who paid their fees
within the first six months of the year 2000.
Narrow your search
Sometimes, you might need to find records that match certain criteria
while at the same time excluding others (for example, finding all of
the records that were added in a given year except for those added in
February, or finding all customers who reside in New York state
except for those in New York City). You can perform these types of
finds by using a combination of multiple find requests and omitting
certain records.
Because FileMaker Pro processes multiple find requests in the order
they are created, it is possible to create very specific, layered
searches in this manner. Omitting records in a search does not delete
them from the database.
To find the records of members who paid their fees in the first six
months of 2000, except for those who paid their fees in February:
1. Choose View menu > Find Mode.
2. Type 1/1/2000 in the Date Paid field.
3. In the status area, click the Symbols pop-up menu. Select range
from the list.
4. After the ellipsis, type 6/30/2000.
5. Choose Requests menu > Add New Request. Notice that the status
area shows that this is the second request.
6. Type 2/1/2000 in the Date Paid field.
Symbols pop-up menu