U.M. (Windows)

Table Of Contents
4-24 FileMaker Pro User’s Guide
Note For information about system formats, see appendix B, “Working
with international files.”
Finding different sets of criteria
You can find all the records in a file (for example, after you’ve created
a found set), find records that match more than one set of criteria (logical
AND search), or find records that match either one set of criteria or
another (logical OR search).
Today’s date in a date field or
calculation field that produces
a date result
// // finds April 4, 1998
(when the current date is
4/4/98)
A time in a time field or
calculation field that produces
a time result
The time as digits, separated by
colons, in the format used when
the file was created (unless Use
System Formats is chosen)
12:53:09 finds 12:53:09
Choose FileMaker Help Index from the Help menu, and then type:
E data, finding
To find Do this
All the records in a file Choose Find All from the Select menu.
A group of records that
match a specific set
of criteria
In one request, enter criteria into as many fields as needed to
make your request specific (creating a logical AND search), and
then click Find (or choose Perform Find from the Select menu). For
example, type Johnson and Personnel to find all people
named Johnson who work in Personnel.
Records that match one
criterion or another
Choose New Request from the Mode menu. (Or use the bookmark
to display the request to duplicate, and then choose Duplicate
Request from the Mode menu.) Enter or edit the criteria, continue
adding new or modified requests for each set of criteria (creating
a logical OR search), and then click Find (or choose Perform Find
from the Select menu). For example, type New York in the first
request and Paris in the second request to find all records that
contain either New York or Paris.
Choose FileMaker Help Index from the Help menu, and then type:
E records, finding
To find Type this in the field Example
?
?