How to Filter Records in a Table in Access 2003

Filtering allows you to retrieve specific information from a table in Microsoft Access 2003. For example, in your recipe collection, you might run a filter to locate all of your breakfast recipes that contain eggs. Filtering by selection is easiest, but filtering with a form is quicker if you want to use multiple criteria to filter. Here are some steps to filter records in a table in Access 2003.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access 2003
• Computer

Filtering by Selection

1. Open the Microsoft Access 2003 program on your computer.

2. Open the table containing the records that you want to filter.

3. Locate a field that contains an instance of the value you want the records to contain. Using the recipe example, you might select a field containing the word "breakfast."

4. Click the "Filter by Selection" icon in the toolbar (or right-click on the selected field to produce a shortcut menu, then select "Filter by Selection"). Access displays a table containing all incidents of the field you selected.

5. To further refine your search, select a second field from the filtered table and continue. For example, if your goal is to find all breakfast items containing eggs, you would next select "eggs" from the filtered table.

Filtering by Form

6. Open a table or form in the Datasheet view.

7. Click "Filter by Form" on the toolbar. A new window will appear.

8. Click the field that specifies the criteria that the records must meet. In the recipe example, if you're looking for breakfast items, click the Meal Type field. A list will appear.

9. Select the value you're searching for ("breakfast"), or type the value into the field.

10. Click the "Apply Filter" icon on the toolbar or use the "Apply/Filter Sort" command found on the Filter menu. You will receive a list of the records that match your specified criteria.

Filtering by Input

11. Open a table, query or form in Datasheet view.

12. Right-click in a field containing the value that you want to filter.

13. In the Filter For box, type the value that you want to find. If you're looking for all breakfast items containing eggs, you would right-click on "breakfast," and then enter "eggs" in the Filter For box.

14. If you want to filter for only one value, press "Enter."

15. If you want to filter for more than one value, press the "Tab" key. This will allow you to keep on refining your filter until you have the set of records you want.

Tips & Warnings

• You can do very complex filtering using the Input method. Consult your user’s manual for more details.
• You can use values in more than one field. The filter will return records that match both criteria. For example, if you specified both "breakfast" and "eggs," you would receive a listing of the breakfast items that contain eggs in the ingredients.