• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 6. Creating Queries > Sorting Query Results

Sorting Query Results

After you've entered your criteria, click in the Sort row under the field by which you want to sort. For example, to sort results by last name, click in the Sort row under the Last Name field.

A down arrow appears. Click the down arrow and choose Ascending or Descending from the list that appears.

INTRODUCTION

In addition to selecting a set of records, you can optionally sort the records in a query using the Sort row. That way, you can view the results in the order you select. You can sort in ascending or descending order.


The sort order is entered. Click the Save button on the Standard toolbar in the main Access window to save the change you made to the query.

Click the Run button to run the query.

Access runs the query and displays the results, sorted in the order you selected (in this case, all clients in Indiana, sorted by last name).

Click the Close button to close the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint