Datasheet

Figure 1-18 The Datasheet view of query
shows the results of the query.
Sorting query results
Here, you examine how you can sort the results of this query. Just as you
sorted in Excel, you are going to select a column and choose between ascend-
ing sort and descending sort. In the bottom half of the QBD, you’ll notice the
Sort row on the grid. This is where you can select either one or multiple sort
columns. If you select multiple sort columns, the query sorts the results in
order of left to right.
Go to the State column and click your mouse on the Sort section. As shown
in Figure 1-19, a down arrow appears, allowing you to select either Ascending
or Descending for that particular column.
Select Ascending and rerun the query. When you ran the query before, the
states were in no particular order. After setting the sort order of the State col-
umn to ascending, the query output simply looks better and more profession-
ally formatted, as shown in Figure 1-20.
28 Chapter 1
05_59978X ch01.qxp 12/1/05 7:46 PM Page 28