You can Filter by selection, form, input, or by using the Advanced Filter/Sort window.

First, find one record that contains the value for which you want to search. Second, select as many criteria as you require for your filter. There are three ways to specify the selection criteria. You can choose the entire field to return all records that match a field value; choose some characters from the start of a selected field to find all records starting with the selected characters; or choose some characters after the start to filter for all records containing the selected characters. Third, click the Filter By Selection button.

Filtering by form. 

Click in a field on a datasheet, form, or subform, then, click the Filter By Form button. Select as many field values from the Filter By Form drop-down list box as you like. Finally, click the Apply Filter button.

Filtering for input. 

Right-click in any table column or form field and make an entry in the Filter For box. After specifying the criteria for a field, you can apply it immediately by pressing ENTER, or you can press TAB and navigate to a new field. Enter new criteria. After entering your last criteria, press ENTER.

Using the Advanced Filter/Sort window. 

Choose Records, Filter, Advanced Filter/Sort to open the Advanced Filter window. It applies to a single table or query. Drag and drop fields from the field list to the design grid. Enter criteria expressions for all fields that you select. If you want, choose sort rules. Click the Apply Filter button to view the outcome of the filter criteria.

<<<Back Home Next>>>