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

Sorting Records

You can change the order in which records appear in a table, query results, forms, or reports by sorting the records. You can select a field and then sort the records by the values in that field in either ascending or descending order. Ascending order means that records appear in alphabetical order (for text fields), from most recent to later, (for date fields), or from smallest to largest (for numeric fields). In Descending order, the order is reversed. You might also want to sort records by more than one field; this is referred to as a secondary sort. For example, in a table containing information about patients, you might need to sort the records first by patient gender, and then, in records with the same patient gender, sort records by age or by preexisting conditions.

Sort Records

In the Datasheet view, display the table, query results, form, or report in which you want to sort records.

To sort multiple columns, rearrange them to be adjacent.

Click the column selector of the column you want to sort. To select another column, press and hold Shift, and then click the column selector.

Click the Sort Ascending button on the Table Datasheet toolbar (A to Z), or click the Sort Descending button on the Table Datasheet toolbar (Z to A).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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