Faster Smarter Microsoft Office System -- 2003 Edition
One of the simplest operations you ll perform with your Access data involves sorting it. You can sort data by using either the datasheet or the data-entry form for a particular table. To sort records, follow these steps:
-
Open the database you want to use.
-
In the database window, double-click the data table or form you want to sort.
-
Click in the field that will be the organizing point for arranging your records. (For example, if you want to sort the records alphabetically by company name , click in the Company field. If you want the records sorted by customers last names , click in the Lastname field.)
-
Click Sort Ascending or Sort Descending in the Standard toolbar. If you click Sort Ascending, the records are arranged from A to Z. If you click Sort Descending, the records appear arranged from Z to A.
Note If you prefer to use the menus , you can choose Sort from the Records menu and then choose Sort Ascending or Sort Descending from the submenu.