Microsoft Office Tutorials and References
In Depth Information
Filtering to Find Information
Filtering by form
Filtering by form is a sophisticated filtering method. It permits you to filter in
more than one field using an OR search. For example, you can tell Access to
look in the Last Name field for people named Martinez, as well as look in the
City field for Martinez es who live in Los Angeles or San Francisco. Moreover,
you can use comparison operators in the filter operation. Follow these steps
to filter by form:
1. In Datasheet view, go to the Home tab, click the Advanced button, and
choose Filter by Form on the drop-down list.
Only field names appear on the datasheet, as shown in Figure 4-3.
2. Click in a field, open its drop-down list, and enter a comparison value
or select a value on the drop-down list.