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 .
Search WWH ::




Custom Search