Sort Multiple Columns in a Query

Sort Multiple Columns in a Query

As you learned in the previous section, you can sort the rows your query returns. You can also create sorts within a sort. For example, you can sort by state and then within a state, you can sort by last name and then by first name. You specify the sort in the order you want the sort to occur. If you want to sort by state and then by last name within a state and then by first name within last name, you enter the sort in the following order: city, last name, first name. Your sort order may not agree with the order in which you want to display fields. In such a case, you can use fields that do not display to enter your sort order. To prevent a field from displaying, deselect the Show box on the Show row.

To sort multiple columns:

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.   Choose the field names you want to sort by in the order you want to sort.

4.   Under the fields you want to sort by, choose Ascending or Descending.

5.   Deselect the Show button for the columns you do not want to display.

          6.   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