O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Fields to a Query

If you created your query from scratch (as in the preceding set of steps), the first thing you need to do is add the fields you want to work with. You can also use this same procedure to add fields to an existing query.

Adding More Tables

You can add tables to your query at any time. Just click the Show Table button on the toolbar or select Query, Show Table. Then select the table(s) you want and click Add. Click Close to return to your query design.

There are three ways to add a field to a query. All methods are easy; try all of them to see which you prefer. Here's the first method:

  1. Click in the Table row of the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required