How To

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

Contributor
By eHow Contributing Writer
(4 Ratings)

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:

  1. Step 1

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

  2. Step 2

    Click the Query tab, then click New.

  3. Step 3

    When the Query window appears, select Simple Query Wizard.

  4. Step 4

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

  5. Step 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. Step 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.

Post a Comment

Post a Comment
  • Have you done this? Click here to let us know.
I Did This

Related Ads

Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US

eHow Computers
eHow_eHow Technology and Electronics