User manual

3-4 FileMaker Pro User’s Guide
To find Type this in the field Example
Finding ranges of information
Use this Example
To find values that are operator
Less than a specified value. < <40
<9/7/1999
<M
Less than or equal to a specified <= <=95129
value. or ≤ (Mac OS) ≤05:00:00
<=M
Greater than a specified value. > >95129
>9/7/1999
>M
Greater than or equal to a specified >= >=100
value. or ≥ (Mac OS) >=9/7/1999
≥8:00
≥M
Within the range you specify. A .. or ... 12:30...17:30
range is first to last character in the (two or three 1/1/1999..6/6/
alphabet for text; least to greatest for periods) 2000
numbers; and earliest to latest for A...M
date and time.
Finding data in related fields
You can enter Find criteria in related fields that are displayed in a
portal or directly on a layout.
When you perform a Find in a related field, FileMaker Pro displays
all records in the master file that have a related record matching the
criteria entered in the related field.
For example, suppose you have an invoice file with a portal
displaying line items. To find all invoices listing a Computer, type
Computer in the Item field in the portal. For more information about
related fields, see chapter 8, “Working with related files.”
A Boolean number in a True, Yes, Y, y, T, T finds True, Yes, Y, y, T, t,
number field or in a t, or 1 to find True and 1
calculation field that values
0finds False, No, N, n, F, f,
produces a Boolean
False, No, N, n, F, and 0
result
f, or 0 to find False
values
A date in a date field or
in a calculation field that
produces a date result
The date as digits,
separated by a
nonnumeric character, in
the format used when the
file was created (unless
Use System Formats is
chosen)
3/3/2000 finds
3/3/2000,
March 3, 2000, and
3-3-2000
Today’s date in a date //
field or in a calculation
field that produces a date
result
// finds April 4, 2000
(when the current date is
4/4/2000)
A time in a time field or The time as digits, 12:53:09 finds 12:53:09
in a calculation field that separated by colons, in
produces a time result the format used when the
file was created (unless
Use System Formats is
chosen)
Invalid dates, times, or
calculated date or time
results
? ? finds:
Next Tuesday or 2/33/2000
in a date field, or midnight
in a time field
Ranges of information See the next section.
Note System formats is documented in Help. Choose Help menu >
Contents and Index, click the Index tab, and type system formats.