Contact Us
Log In Contact Us
Filter by Form | CustomGuide
Limited Free Version
Access Basic

Filter by Form

How to Filter by Form in Access

Filter by Form

The Filter by Form feature makes it easy to create a filter using more than one criterion. You can filter by form when working in tables, forms, or queries.

  1. Click the Advanced Filter Options button.
  2. Select Filter by Form.
    Filter by Form

    In the Filter by Form window, you can specify your filter criteria by using the two tabs at the bottom of the window.

    The Look for tab will only display records that match all the criteria set there.

    If you specify filter criteria on an Or tab, Access will display records that match either the criteria on the Look for tab, or criteria on the Or tab.

  3. Click the empty cell below the field you want to filter.
  4. Click the list arrow and select the value you want to use to filter the records.

    You can also enter filter criteria by typing it yourself.
    Filter by Form
  5. Repeat Steps 3-4 to add additional criteria.
    Filter by Form
  6. (Optional) Click the Or tab and enter alternative criteria.

    Any criteria added here will be searched for in addition to your original criteria.

  7. Click the Apply Filter button.
    8. Filter by Form

Access applies the filter.
You Get:
  • LinkedIn-ready certificate
  • Skill assessments
  • Bite-sized, interactive lessons
  • Saved progress