Recommendations for a filtering method to use in a table, query, or form

Filter By Selection, Filter By Form, and Filter For Input are the easiest ways to filter records. If you can easily find and select in the form, or datasheet an instance of the value you want the filtered records to contain, use Filter By Selection. If you want to choose the values you're searching for from a list without scrolling through all the records in a datasheet or form, or if you want to specify multiple criteria at once, use Filter By Form. If the focus is in a field in a form or datasheet and you just want to type in place the exact value you're searching for or the expression whose result you want to use as your criteria, use Filter For Input. For complex filters, use Advanced Filter/Sort.

Note   In a report, you can't create a filter using the filtering techniques mentioned previously. However, a report (as well as a form) can inherit a filter. For more information, click .

Return to Create a filter in a table, query, or form