How to Create a Microsoft Access Query That Uses More Than One Field

Queries allow you to display information in different ways. For example, suppose you have a table that contains complete addresses for your friends, but you just want a list of names and telephone numbers. You could create a two-field query to accomplish this. These instructuctions apply to MS Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Open the database window (pressing the F11 key will open it).

2. Click the Query tab, then click New.

3. When the Query window appears, select Simple Query Wizard.

4. Select the table that you want to use in the query.

5. Select the two (or more) fields that you want to display in the query results, then click on the > symbol to move the fields into the window on the right.

6. Follow the directions that the wizard provides. Click Finish when ready. Your query opens. In the example given, you would see two columns - one containing your friends' names and another showing their telephone numbers.

Tips & Warnings

• To filter query results further - only display the friends whose names begin with B, for example - see the related eHow "Create a Microsoft Access Query That Uses Multiple Criteria in One Field."
• You can use your query results as the basis for a form or report.