Share this Page URL

Chapter 6. Sorting, Filtering, and Retri... > Applying a Filter to Data in a Table - Pg. 206

Sorting, Filtering, and Retrieving Data 206 Access has one other method for filtering records, called Filter For or Filter For Input. To use this method, right- click in the field whose values you want to filter, and then enter the value or the expression you want to use as the filter in the box following the Filter For command. Here's the Filter By Form window showing the filter we created in the previous section: