Microsoft Office Tutorials and References
In Depth Information
Zack wants the Employer table’s EmployerID, EmployerName, City, ContactFirstName,
ContactLastName, and Website fields to appear in the query results. You’ll add each of
these fields to the design grid.
To select the fields for the query, and then run the query:
1. Drag EmployerID from the Employer field list to the design grid’s first column Field text
box, and then release the mouse button. See Figure 3-3.
Field added to the design grid
release mouse button here
the field will
appear in the
In the design grid’s first column, the field name EmployerID appears in the Field text box,
the table name Employer appears in the Table text box, and the check mark in the Show
check box indicates that the field will be displayed in the datasheet when you run the
query. Sometimes you might not want to display a field and its values in the query results.
For example, if you are creating a query to show all employers located in Massachusetts,
and you assign the name “EmployersInMassachusetts” to the query, you do not need to
include the StateProv field value for each record in the query results—every StateProv field
value would be “MA” for Massachusetts. Even if you choose not to include a field in the dis-
play of the query results, you can still use the field as part of the query to select specific
records or to specify a particular sequence for the records in the datasheet.
2. Double-click EmployerName in the Employer field list. Access adds this field to the second
column of the design grid.
3. Scrolling the Employer field list as necessary, repeat Step 2 for the City ,
ContactFirstName , ContactLastName , and Website fields to add these fields to the
design grid in that order.
Trouble? If you double-click the wrong field and accidentally add it to the design grid,
you can remove the field from the grid. Select the field’s column by clicking the pointer
on the bar above the Field text box for the field you want to delete, and then press the
Delete key (or click Edit on the menu bar, and then click Delete Columns).
Having selected the fields for Zack’s query, you can now run the query.