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

Chapter 5. Finding and Sorting Records > Running Multiple Sorts

Running Multiple Sorts

A multiple sort allows you to precisely arrange the order of your database records. When you sort more than one field at once, the precedence is based on the order in the Sort Records dialog box. Fields listed first in the box's right-side list will take precedence over fields listed later. Looking at our real estate example, if the Street field is listed before the Number field the records will be first sorted by the street name (A to Z) and then by the address number (1 to 100) (Figure 5.45).

Figure 5.45. By controlling the sort order within the Sort Records dialog box, all Ashbury homes appear first (with their house numbers in ascending order), followed by all the Carmel homes.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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