Database Reference
In-Depth Information
Now let's add a second criterion that filters out only the records that have a Region
value of CA.
5
Click the
Advanced Filter Options
button and then click
Filter By Form
to redisplay
the filter form, which still contains the current filter criterion.
TIP
No matter what method you use to enter filter criteria, the criteria are saved as
a form property and are available until they are replaced by other criteria.
6
Click the second box to the right of the
City/State/ZIP
label (the box that normally
displays the state or region), click the arrow that appears, and then in the list, click
CA
.
Only records matching both of the criteria will be displayed.
7
Click the
Apply Filter
button to display the first of three records that have both a
Region
value of
CA
and
LastName
values starting with
S
.
Next let's enter alternative filtering criteria.
8
Switch back to the filter form, and at the bottom of the form page, click the
Or
tab.
9
Enter
s*
in the second
Name
box, and click
WA
in the list for the second
City/State/
ZIP
box.
10
Click the
Apply Filter
button to find and display records that have either a
Region
value of
CA
and
LastName
values starting with
S
,
or
a
Region
value of
WA
and
LastName
values starting with
S
.