| -
| | After you've displayed the query you want to modify in Design view, click the field you want to add in the field list and drag it to an empty column. | -
| | The field is added. Click the Save button on the Standard toolbar in the main Access window to save the query design. | -
| | Click the Run button to run the query. | -
| | Access runs the query and displays the results; the field you added (in this case, Artist Phone ) is included. Click the Close button to close the query. | INTRODUCTION Suppose that you forgot to add a particular field when you built your query. If so, you can use the list of fields that appears in the query design window to add fields to the query. | TIP Change Field Order You can also change the order in which the fields are listed in the query. To do so, click right above the field name . Then drag the column to the location you want. | |