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.
Search WWH ::




Custom Search