Adding Fields to a Query
Whether you create your query from scratch or modify an existing query, the Query Design view provides the capability to add the table fields that will be contained in the query. Be sure that the tables that contain the fields for the query are present in the design window.
Adding More Tables You can add tables to your query at any time. Click the Show Table button on the toolbar, or select Query, Show Table. Then, select the tables you want and click Add. Click Close to return to your query design.
To add a field to the query, follow these steps:
As you add the fields to the query from left to right, be advised that this will be the order in which the fields appear in the query when you run it. If you need to change the field that you've placed in a particular field column, use the Field drop-down list in the column to select a different field.
Figure 18.3. Scroll through the Field list to locate the field you want to place in the query.
Quickly Add Fields to the Query You can also add fields to the query directly from the tables that appear in the Table pane of the Query Design view. In one of the tables, locate the field that you want to place in the first field column and double-click the field name (in the table itself). The field appears in the Field box in the first field column of the query grid. To add the next field, locate it in a table, and then double-click it. This method enables you to select the fields from specific tables rather than scrolling through a long, continuous list of field names .