How to Create a Query From a Filter in Access 2003

Creating a Query from a Filter in Access 2003 is accomplished by performing the "Advanced Filter/Sort" feature. This feature allows you to sort information from a single table in the database. Follow these steps to create a Query from a Filter in Access 2003.

Things You'll Need

• Computer with Access 2003

Instructions

1. Get the table you want to Query. Open the table in "Datasheet View."

2. Open the "Filters" window. Find the "Filters" window by choosing "Records" then "Filter" and finally, "Advanced Filter/Sort."

3. Choose the field you want. A box appears with the table name and all the fields. Double-click on the desired field.

4. Choose the criteria and limits. In the first column choose your criteria and then type the limit you want.

5. Add more criteria. Repeat steps 3 and 4 to add more fields and limits.

6. Sort the results. Choose a field to sort the results by choosing the field you want and clicking on "Descending" or "Ascending" in the drop-down list.

7. Apply the results. When finished, click on the "Apply" button to show your filter results.

Tips & Warnings

• Be sure to save your filter in "Design View" if you want to keep the results.

• You can also choose a field in the "QBE" grid. The fields are in the drop-down list.