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:

  1. In Design view, 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 to see the results.

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.


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.