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