Microsoft KB Archive/124713

= ACC2: GP Fault Using Number As Group Header Name =

Article ID: 124713

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q124713



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



SYMPTOMS
When you use a numeric expression (such as =1) as a group header name in a report, you receive one of the following error messages when you print or preview the report:


 * ORDER BY clause [ ] conflicts with GROUP BY clause

-or-
 * MSACCESS caused GP Fault in MSAJT200.DLL

NOTE: Users creating dummy groups by including =1 in the Sorting and Grouping dialog box may encounter this problem.



CAUSE
This problem occurs only if you have installed the Microsoft Access version 2.0 Service Pack. The Microsoft Jet database engine version 2.5 that is included with the Service Pack introduces the ability to order data by ordinal numbers. When you try to use an ordinal number as the name of a group header in a report, the Microsoft Jet database engine erroneously attempts to interpret the ordinal number.



RESOLUTION
Put quotation marks around the number to make it a text string (for example, ="1").



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0 using Jet 2.5. This problem no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem
WARNING: Following these steps may cause a general protection (GP) fault on your computer. Save and close any open work on your computer before following these steps.

NOTE: In order to reproduce this problem, you must have the Microsoft Access version 2.0 Service Pack installed.

 Start Microsoft Access and open any database. Create a new report based on any table. From the View menu, choose Sorting And Grouping. In the first Field/Expression row, type =1. Set the group's GroupHeader property to Yes. Add a control (such as a field or label) to the group header section.</li> Preview the report. You receive the error message:

MSACCESS caused GP Fault in MSAJT200.DLL

The error message

ORDER BY Clause [ ] conflicts with GROUP BY clause.

is generated if you have multiple group headers and the numeric group header is the outermost group.</li></ol>

<div class="references_section">