Click on Filter By Form icon in the toolbar. Click the
field in which you want to specify the criteria that
records must meet to be included in the filtered set of
records.
Enter your criteria by selecting the value you're
searching for from the list in the field (if the list
includes field values), or by typing the value into the
field.
To find records in which a particular field is empty or
not empty, type Is Null or Is Not Null into the field.
(You can select these options from the list in fields with
a Memo, OLE Object, or Hyperlink data type, and in
calculated fields in queries.)
Note: When you save a table or form, Microsoft Access
saves the filter. You can reapply the filter when you need
it, the next time you open the table or form.
When you save a query, Microsoft Access saves the filter,
but it does not add the filter criteria to the query
design grid. You can reapply the filter after you run the
query, the next time you open it.
