Sorting Data in a Select Query
You can control how records appear in Query datasheet view by using the sort feature.
To modify the select query to sort records:
- In Design view, click Sort under the field that you want to sort on.
- Click the drop-down arrow and select Ascending or Descending.
- Run the query to see the results.
To sort the results of a select query while in Datasheet view:
- Click in the field that you want to sort on.
- Click the
Sort Ascending or
Sort Descending toolbar button.
If two fields have the sort option selected, Access will sort first by the field that appears to the farthest left.
In Datasheet view, click the Records menu. Point to Sort, and select Sort Ascending or Sort Descending.