Sort a Query
When creating a query, you can sort the rows you retrieve in ascending or descending order by choosing the option you want on the Sort row in Query Design view.To perform a sort:
- 1. Open a table or query in Query Design view.
- 2. Choose the field names you want to retrieve in the order you want to retrieve them.
- 3. Under the field you want to sort, click the down-arrow and then choose Ascending or Descending.
- 4. Click the Run button. Access retrieves the columns you chose and displays the rows in the order you specified.
Post a Comment