When working in Access sort data to make it easier to work with, including text-based and numerical data in your Access database.
Access 2007 also offers two options when sorting based on a numerical value. These options are described in the table below:
Sort Option Also Called Description Smallest to Largest Ascending Values closest to 1 are displayed first Largest to Smallest Descending Values farthest from 1 are displayed first
The sort commands in the Sort & Filter group on the Ribbon can also be use to begin a sort.