Tutorial

Lesson 3 | Finding and sorting records 17
Notice that the status area shows that there are two requests.
4. Type London in the City field of this second request.
5. Click Find in the status area.
Your find request returns a found set of six records for six members
who live in either New York or London.
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, 2008 and June 30, 2008:
1. Choose View menu > Find Mode.
2. Type 1/1/2008 in the Date Paid field.
3. In the status area, click the Symbols pop-up menu. Select range
from the list, or type an ellipsis (...).
Your find request should now have 1/1/2008... in the Date Paid
field.
4. Immediately after the ellipsis (...), type 6/30/2008.
5. Click Find.
Your search returns six records, for six members who paid their fees
within the first six months of the year 2008.
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.
Number of requests
Symbols
pop-up menu