Microsoft Office Tutorials and References
In Depth Information
Querying: The Basics
Choosing which fields to query
After you choose which tables to query, the next step is to choose which
fields to query from the tables you selected. The object is to list fields from
the Table pane in the first row of the Design grid. Fields whose names you
enter in the first row of the Design grid are the fields that produce query
results, as demonstrated by Figure 4-5.
Access offers these techniques for listing field names in the first row of the
✦ Dragging a field name: Drag a field name into a column on the Design
grid. The field name appears on the grid, as does the name of the table
that you drag the field name from.
✦ Double-clicking a field name: Double-click a field name to place it in the
next available column in the Design grid.
✦ Choosing a table and field name: Click in the Table row, open the
dropdown list, and choose the name of a table. Then, in the Field box directly
above, open the drop-down list and choose a field name.
✦ Selecting all the fields in a table: In the unlikely event that you want all
the fields from a table to appear in the query results, either double-click
the asterisk (*) at the top of the list of field names or drag the asterisk
into the Design grid. Access places the name of the table followed by
an asterisk in the Field text box. The asterisk signifies that all the fields
from the table are included in the query.