Microsoft KB Archive/304249

= ACC2002: &quot;Sorting and Grouping&quot; Dialog Box Has Been Replaced with the &quot;Group Level Properties&quot; Dialog Box for Data Access Pages =

Article ID: 304249

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q304249



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article shows you how to access the Group Level Properties dialog box for a data access page.



MORE INFORMATION
In Microsoft Access 2000, to access the Sorting and Grouping dialog box, you click Sorting and Grouping on the View menu.

Microsoft Access 2002 does not have the Sorting and Grouping dialog box. In Access 2002, this dialog box has been replaced with the Group Level Properties dialog box.

For an example of how to create a grouped data access page and to access the Group Level Properties, use one of the following methods.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Method 1

 * 1) Open the Northwind sample database.
 * 2) In the Database window, click Pages under Objects, and then click New to create a new data access page.
 * 3) In the New Data Access Page dialog box, click Page Wizard, click the Categories table in the Choose the table or query where the object's data comes from box, and then click OK.
 * 4) Add all the fields from the Available Field list to the Selected Field list, and then click Next.
 * 5) Add the CategoryID field as a grouping level, and then click Finish.
 * 6) In Design view of the data access page, right-click in the white space outside the design grid, and then click Group Level Properties.

Method 2

 * 1) Open the Northwind sample database.
 * 2) In the database window, click Pages under Objects, and then click New to create a new data access page.
 * 3) In the New Data Access Page dialog box, click Page Wizard, click the Categories table in the Choose the table or query where the object's data comes from box, and then click OK.
 * 4) Add all the fields from the Available Field list to the Selected Field list, and then click Next.
 * 5) Add CategoryID as a grouping level, and then click Finish.
 * 6) In Design view of the data access page, right-click in the Categories-Category ID header section, and then click Group Level Properties.

NOTE: If the data access page has multiple grouping levels, Method 1 will bring up the group level properties for the top grouping level on the page. To bring up the group level properties for the lower grouping levels on the page, use Method 2.

