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

Sorting Records

Before getting to the specifics of select queries, let's first take a look at the various ways Access enables you to sort a table. Sorting means that you place the records in alphabetical order based on the data in a field (or numerical order if the field contains numeric or currency data). For example, suppose you have a table of customer names and addresses, and you want to see all the customers who are from California. All you have to do is sort the table by the data in the State field, and all the records with CA in this field appear together.

Sorting on a Single Field

Because sorting is such a common practice, the Access programmers made it easy to perform quick sorts on a single field. To try this, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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