## PRA: Groups/Totals Report Wizard Date Formats Are Inconsistent

Article ID: Q124400
Creation Date: 29-DEC-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

- Microsoft Access version 2.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you create a report with the Groups/Totals Report Wizard, the format for Date/Time fields on the report is not consistent from the detail section to the group footer section.

CAUSE

This problem occurs only when you select the Ledger style for reports created with the Groups/Totals Report Wizard.

RESOLUTION

Open the report in Design view and select the appropriate format for the Date/Time field in the group footer section.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

1. Open the sample database NWIND.MDB.
2. Use the Groups/Totals Report Wizard to create a new report based on the Invoices query.
3. In the Available Fields box, select Country, and then choose the ">" button. Repeat for the Order Date, Quantity, and Freight fields. Choose the Next button.
4. In the Available Fields box, select Country, and then choose the ">" button. Repeat for the Order Date field. Choose Next.
5. In the Group box next to the Order Date field, select Month. Choose Next.
6. In the Available fields box, select Freight, and then choose the ">" button. Choose Next.
7. Select the Ledger option button and then choose the Finish button. Note that the Order Date field in the new report is formatted differently in the detail sections than it is in the group footer sections.
8. View the report in Design view. Note that the format for the Order Date field in the detail section is Medium Date, while the format for the Order date field in the group footer section is blank.

REFERENCES

Microsoft Access "User's Guide," version 2.0, Chapter 20, "Report Basics," pages 490-492

> 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.

©1997 Microsoft Corporation. All rights reserved. Legal Notices.
Additional reference words: 2.00 reportwizard
KBCategory: kbusage
KBSubcategory: RptWizg