GCFLearnFree.org

I wish I would have found you ages ago.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2007
  • Sorting Records

Access 2007

Single page view print copy

Sorting Records

Sorting on Text Values

When Access 2007 sorts on a text value, it offers the two options described in the table below:

Sort Option Also Called Description
A to Z Ascending Values closest to A are displayed first
Z to A Descending Values closest to Z are displayed first

To sort based on a text value

To sort based on a text value:

  • Click the drop-down arrow at the top of the field you wish to sort.
    A to Z SortSorting A to Z
  • When the menu appears, select either the Sort A to Z or the Sort Z to A option.
    • With A to Z, the records will be sorted based on the chosen field's value with the value closest to A at the top of the table, as seen below.
      A to Z Sort ResultsRecords Sorted A to Z on Category
    • With Z to A, the records will be sorted the using the chosen field's value with the value closest to Z at the top of the table.

    The sort command section in the Sort group on the Ribbon is another way to begin the sort.

previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.