Datasheet

7. The Criteria grid section specifies not only the columns for the query, but also any sorting or
filtering you require. As a simple example, use the drop-down lists in the Sort Type column
of the grid to set the sort order for the rows as Ascending by
ItemName, then Descending by
ItemPrice, as shown in Figure 1-16. Select the columns named MenuItemType, ItemName,
PizzaToppings, and GraphicFileName. Again, you will see the equivalent SQL statement
appear in the SQL pane below the grid.
Figure 1-16: Sorting by ascending and descending order
8. Click the Execute button (the button in the toolbar with a red exclamation mark) and the results
of executing this query appear in the bottom pane of the Query Editor window (see Figure 1-17).
15
Getting Started
04_588079 ch01.qxd 11/29/05 3:48 PM Page 15