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

Sorting Data in a Database

To sort data in a database, first decide which field to sort by. For example, an address database could be sorted by Last Name or by City (or it could be sorted by Last Name within City within State). Each of these sort fields is considered a key.

You can use up to three keys when sorting your database. The first key in the preceding example would be State, the second would be City, and the third would be Last Name. In other words, all the records would be sorted by state. Then within a state, they would be sorted in order by city. And within each city, the names would be sorted in alphabetical order by last name. You can sort your database in ascending or descending order.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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