Create a filter in a table, query, or form

There are four methods you can use to filter records: Filter By Selection, Filter By Form, Filter For Input, and Advanced Filter/Sort.

What do you want to do?

See recommendations for choosing a filtering method

See a comparison of each filtering method for help in deciding which one to use

Use Filter By Selection

Use Filter By Form

Use Filter For Input

Use the Advanced Filter/Sort window