Sorting Data in a Select Query

To modify the select query to sort records:

1. Click Sort: under the field that you want to sort on.
2. Click the drop-down arrow and select Ascending or Descending.
3. Run the query by clicking the Run button.

To sort the results of a select query while in Datasheet view:

1. Click in the field that you want to sort on.
2. Click the Sort Ascending or Sort Descending toolbar button.

To specify that a query will display result records in a certain order, first click Sort: under the field that you want to sort by. Click the drop-down arrow, and select Ascending or Descending. Run the query to see your results. To sort records in Datasheet view, click in the field you want to sort by, and then click the Sort Ascending or Sort Descending toolbar button.