O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting a Field in a Query

After all this complicated criteria discussion, you will be happy to know that sorting is fairly straightforward. To sort any field, just follow these steps from the query results window:

  1. Click in the sort row for the field you want to sort. A down arrow for a drop-down list appears.

  2. Open the drop-down list and select Ascending or Descending.

Later, if you want to cancel sorting for this field, repeat these steps, but select (not sorted). Refer back to Lesson 18 for more information about sorting.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required