How to Create a Query Using More Than One Field in Access 2003

A single-field query in Microsoft Access 2003 extracts specific information from a database, such as “everybody with a birthday in November.” You can add other fields to this--say, making the query “everybody with a birthday on an even day in November who is under 60.” Here’s how to use more than one field in Access 2003 queries.

Instructions

Difficulty: Moderate

Things You’ll Need:

• Microsoft Access 2003

1. Open the Access 2003 database that holds the information you want to extract.
2. To open a new query, click the object "Query."
3. Click on "Query Wizard," which will take you-step by-step through creating a multi-field query.
4. Following the Wizard’s instructions, select as many database fields as you need.
5. Click the caret symbol (>) to move the selected fields from your original window to the new window.
6. When you’ve selected all of your fields, click "Finish" on the Query Wizard to view your new database.

Tips & Warnings

• A query can select pertinent data from any database on your system.
• Further fine-tune your query. Choose a filter that can address records rather than fields.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.