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
-
-
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.
-
1
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.