Article ID: 304255 - View products that this article applies to.
This article was previously published under Q304255
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2002 version of this article, see 304250
When you are working with data in Access, you may want to view your information sorted in a different fashion than it currently appears. This article shows you how to sort records in a table, a query, a form, or a report in an Access database.
Sorting Records in Form View or in Datasheet ViewTo sort records in Form view or in Datasheet view, follow these steps:
Sorting with SubdatasheetsIn Datasheet view, when you sort the subdatasheet for one record, Microsoft Access sorts all the subdatasheets at that level. In a datasheet or subdatasheet, you can select two or more adjacent columns at the same time, and then sort them. Access sorts records starting with the leftmost selected column. When you save the form or datasheet, Access saves the sort order.
Sorting Records on a Report