ACC2000: How to Sort Records in an Access Database (304255)


The information in this article applies to:

  • Microsoft Access 2000
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.

SUMMARY

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.

MORE INFORMATION

Sorting Records in Form View or in Datasheet View

To sort records in Form view or in Datasheet view, follow these steps:
  1. Start Microsoft Access, and then open the database that you are working with.
  2. Open the table or the form whose data you want to view.
  3. Click the field that you want to use for sorting records. To sort records in a subform, click the field that you want to sort. To sort records in a subdatasheet, display the subdatasheet by clicking its expand indicator, and then click the field that you want to sort.
  4. On the Records menu, point to Sort, and then click Sort Ascending or Sort Descending.NOTE: In a form, you can sort on only one field at a time.

Sorting with Subdatasheets

In 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

  1. Start Microsoft Access, and then open the database that you are working with.
  2. Open the report in Design view.
  3. On the View menu, click Sorting and Grouping to display the Sorting and Grouping dialog box.
  4. In the first row of the Field/Expression column, select a field name or type an expression.

    NOTE: When you fill in the Field/Expression column, Microsoft Access sets the sort order to Ascending.
  5. You can sort on up to 10 fields or expressions in a report. To sort your report on more than one field, add another field or expression to the Field/Expression column. The field or expression in the first row is the first sorting level. The second row is the second sorting level, and so on.

REFERENCES

For additional information about sorting data in Microsoft Access, click the "Finding and Sorting Data" topic on the Microsoft Access 2000 Help page at the following Microsoft Web site:

Microsoft Access 2000 Help

Modification Type:MajorLast Reviewed:7/21/2006
Keywords:kbhowto KB304255
©2004 Microsoft Corporation. All rights reserved.