1-866-245-5224 sales@keystonelearning.com

Access 2007: Filter by Selection

Access 2007: Filter by Selection

Filter by Selection is one of the fastest ways to filter your list. With this option, all you need to do is highlight the filter criteria in your table or form and then choose Filter by Selection. Your list will quickly filter based on the data that is selected.


Figure 27. Filter by Selection Drop-Down List

Applying a Filter by Selection

1.       Open the Table or Form in Datasheet View you want to filter

2.       Select the data you want to filter by

3.       Choose the Selection command in the Sort & Filter group on the Home tab

4.       Choose your Filter by Selection option

Removing a Filter by Selection

1.       Click the field heading of the column you want to remove the filter from

2.       Choose Clear Filter From [Field Name]