ACC2000: The Sort-Order Selection Dialog Box in the Report Wizard Has No "Summary Options" Button (314587)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q314587
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).

SYMPTOMS

When you are using the Report Wizard to create a report and you are prompted to specify the sort order for your records, the Summary Options button may not be present in the sort-order selection dialog box.

CAUSE

This issue can occur if there is no numeric data in the query or table on which the report is based, or if you do not add any grouping levels in the Report Wizard.

RESOLUTION

To resolve this issue, make sure that you include numeric data in the report's data source and that you add a grouping level after you select the fields that you want to include in the report.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database, Northwind.mdb.
  2. In the Database window, click Reports under Objects, and then click New.
  3. In the New Report dialog box, click Report Wizard, click Products under Choose the table or query where the object's data comes from, and then click OK.
  4. In the Available Fields box, double-click ProductID, ProductName, and Discontinued, and then click Next.
  5. When you are prompted about whether you want to add any grouping levels, click Next.
Note that there is no Summary Options button in the next dialog box.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb kbui KB314587
©2004 Microsoft Corporation. All rights reserved.