Microsoft Office Tutorials and References
In Depth Information
Querying: The Basics
Moving field columns on the Query grid
The order in which field names appear in the
Query grid is also the order in which they
appear in the query results (refer to Figure 4-5).
Follow these steps to put field columns in the
right order in the Query grid:
1. Click a column’s selector button to select
This button is the narrow gray box directly
above the field name. The pointer turns
into a downward-pointing arrow when you
move it over the selector button.
2. Click the selector button again and drag
the column to the left or right.
Whether a field’s Show check box is selected in the Query grid determines
whether its results are part of the query results. Deselect the Show box if a
field is necessary for producing records in a query but not necessary in the
query results. By the way, after you save and reopen a query, Access moves
deselected Show fields to the right side of the Query grid, where you usually
have to scroll to see them.
Entering criteria for a query
What separates a run-of-the-mill query from a supercharged query is a
criterion, an expression or value you enter on the Criteria line under a field. Enter
criteria on the Criteria line of the Query grid. By entering criteria, you can
pinpoint records in the database with great accuracy. In Figure 4-7, the Query
grid instructs Access to retrieve orders with invoices due before January 1,
2012 that charged more than $2000 and were shipped to Massachusetts (MA),
Connecticut (CT), or New York (NY).
criteria in a