Microsoft KB Archive/314587

= ACC2000: The Sort-Order Selection Dialog Box in the Report Wizard Has No &quot;Summary Options&quot; Button =

Article ID: 314587

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

Additional query words: prb

Keywords: kbui kbprb KB314587

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.