Microsoft Office Tutorials and References
In Depth Information
Adding, Finding, and Querying Data
Filter by Form
1 In the Navigation pane,
double-click the form you
want to use to sort records.
2 Click the Home tab.
3 Click the Advanced button.
4 Click Filter By Form .
E A blank form appears.
5 Click in the field by which you
want to filter.
6 Click the that appears and
choose a criterion.
7 Repeat Steps and to add 6
more criteria to the filter.
F You can set OR criteria using the
tab at the bottom of the form.
8 Click the Toggle Filter button to
filter the records.
To remove the filter, you can click
the Toggle Filter button again.
Then, click the Advanced button
and click Clear All Filters .
How do I filter by exclusion?
Click in the field that you want to
filter in the form, click the
Selection button on the Home tab,
and then click an exclusion option.
What are OR criteria?
Setting OR criteria enables you to display records that match one set
of criteria or another. For example, you might set up your filter to
display only those records with the value 46989 OR 46555 in the ZIP
field. After you set a criterion, Access adds an OR tab. If you set an
OR criterion using that tab, Access adds another OR tab, and so on.