Free E-Books

Simply include the OrderDate field in the QBE grid, set the sort order for the
OrderDate field, and uncheck its Show box. Access sorts the data by the OrderDate field even
though the field is not shown in the query??™s results.
If you save a query that has an unused field (its Show box is unchecked and no criteria
or sort order is applied to the field), Access eliminates the field from the query. The next
time you open the query, the field will not be included in the query??™s design.
Changing the Sort Order
When viewing a recordset, you often want to display the data in a sorted order. You may want to
sort the recordset to make it easier to analyze the data (for example, to look at all the
tblProducts sorted by category).
CAUTION CAUTION
139
Selecting Data with Queries 4
Sorting places the records in alphabetical or numeric order. The sort order can be ascending (0 to 9
and A to Z) or descending (9 to 0 and Z to A). You can sort on a single field or multiple fields.
You input sorting directions in the Sort row in the QBE grid.


Pages:
418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442