Database Reference
In-Depth Information
SEE ALSO
For more information about the Query Designer, see the next section,
“Creating queries manually.”
Suppose we want to use the CustomerID, Address, Country, and OrderID fields in the
query, but we don't want to display these fields in the results datasheet. Let's hide
them, and also sort the results.
11
In the
Show
row, clear the check boxes for
CustomerID
,
Address
,
Country
, and
OrderID
.
12
In the
Sort
row, click the
PostalCode
field, click the arrow that appears, and then
click
Ascending
to sort the results on this field.
The fields with cleared check boxes will not appear in the query's results.
13
On the
Design
tool tab, in the
Results
group, click the
Run
button to display the
datasheet with the new results.
Four fields no longer appear in the results datasheet, and the extracted records are sorted on
the PostalCode field.