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

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 products, you might need to view information about specific prices for each product. You can sort the records first by product and then, in records with the same product, sort the records by price.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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