PRB: Report Detail Items Appear in Group Header

Article ID: Q109718
Creation Date: 06-JAN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0 and 1.1

SYMPTOMS

The Groups/Totals ReportWizard places controls in the group header section of the report that should be in the report's detail section.

CAUSE

This problem occurs if the report is based on a query that contains a calculated field.

RESOLUTION

To work around this behavior, move the calculated field to the first column in the query grid. Or convert the query to a make-table query, and then base your report on the make-table query's resultant table, instead of on the original query.

MORE INFORMATION

Steps to Reproduce Behavior

 1. Open the sample database NWIND.MDB.

 2. Create a new query based on the Customers table.

 3. Drag the Customer ID, Company Name, and Contact Name fields onto the
    query grid.

 4. Enter the following expression in the Field row of the fourth column
    of the grid:

       IIF([customer id] = "ALWAO", "yes", "no")

 5. Save the query as Group/Total.

 6. Choose the Report button in the Database window, then choose New.

 7. In the Select A Table/Query box, select the Group/Total query.

 8. Choose the ReportWizards button.

 9. Select Groups/Totals in the Which AccessWizards Do You Want? box,
    and then choose OK.

Click the ">>" button, and then choose Next.

Select the Customer ID field and then click the ">" button.

Select the Company Name field and then click the ">" button. Choose
    Next.

At each of the next three screens, choose Next.

Choose the Design button.

Note that the report has two group headers. The Company Name header, however, contains both the Company Name field and the Contact Name field, instead of just the Company Name field.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 17, "Report Basics," pages 399-403

Microsoft Access "User's Guide," version 1.1, Chapter 17, "Report Basics," pages 403-407

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.