Sort a Query

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.
  

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati