To look at the dynaset in another way, run the query by clicking the Run button or selecting Run from the Query menu. With this method you should be careful when using a query other than Select Query . Access will actually run your query and manipulate your data as it has been instructed. Only Select Queries will end up in the Datasheet view. Establishing a Sort Order Possibly the most useful task that a database program can do is sort your data.
Access sorts data alpha-numerically.
Creating a query that sorts data can be useful when you want to display data in a form or report, or even if you want that data to appear in order in a combo box or list box on a form. You create a query that sorts the data and then use this query as the data source in a form, report, or box. To specify a sort order in the QBE grid , click the Sort cell for the field you want to choose, then click the arrow in the cell. You can also specify a sort order for more than one field, like asking Access to sort by both First Name and Last Name fields in a mailing list. The sort order will start sorting from the left to the right of the QBE grid from left, so make sure that the Last Name field in the above example occurs on the grid prior to the First Name field.