Microsoft Office Tutorials and References
In Depth Information
Add Fields to the Query
Chapter 8: Querying Data Sources
Microsoft Query adds the
field to the results pane.
5 Repeat steps 3 and 4
until you have added all
the fields that you want
to appear in the query.
6 Click Close.
You can also either
double-click a field name
in a table list, or click and
drag a field name in a
table list and drop it
inside the results pane.
Note: To change where a field
appears in the data grid, first click
the field heading to select the entire
field. Then click and drag the field
heading to the left or right and drop
the field into the new position.
If you want to make changes to a field —
that is, you want to change to a different
field or edit the name displayed in the field
header — click the field heading or click any
cell in the field, click Records, and then click
Edit Column. (You can also double-click the
field heading.) In the Edit Column dialog box
that appears, change the field or edit the
field heading, and then click OK.
If you no longer need a field in the
query, you should delete it from the
data grid. Click the field heading or
click any cell in the field; note that
Microsoft Query does not ask for
confirmation when you delete a field,
so be sure you click the correct field.
Click Records and then click Remove
Column (or just press Delete).