Access 2007

Filtering records

Watch the video! (7:10min)

Download the example to work along with the video.

Filtering records

When you tell Access 2007 to filter your records, you are asking it to:

• Search all of the records in one table
• Find every record in that table that meets the criteria you set
• Display the results for you in the table by hiding the records that do not meet the criteria

You can filter data using what Microsoft calls the Filter by Field and Filter by Selection methods. Additionally, Access 2007 can perform an Advanced Filter, which is essentially a small query that is run on only one table. These options are described in the table below.

Method	Description
Filter by Field	Lists all of the values that have been entered in a specified field so you can choose which value or values you want Access to find.
Filter by Selection	Offers the ability to search records based on the value that is currently selected in a table. You can ask it to find records that: Equal the value Do not equal the value Contain the value Do not contain the value
Advanced Filter	Narrows filtered results further by performing additional filters or sorts.