How to Create a Query From a Filter in Microsoft Access

You can create a query from an existing filter in Microsoft Access instead of designing your query from scratch. These instructions apply to Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Create the filter. (See the related eHow "How to Filter Records in Microsoft Access" for instructions.)

2. Display it in the Filter By Form window or from the Advanced Filter/Sort window.

3. From the toolbar, click the Save As Query button.

4. Name your query.

5. Click OK. Your query appears in the Database window.

Tips & Warnings

• You can also use a query as a filter.
• You can change the query's design if you want.
• Queries are more flexible than filters.