ACC2: GP Fault Using Number As Group Header Name

ID: Q124713

The information in this article applies to:

Microsoft Access 2.0

SYMPTOMS

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

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 [<field name>] 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.

MORE INFORMATION

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.

Preview the report. You receive the error message:

MSACCESS caused GP Fault in MSAJT200.DLL

The error message

ORDER BY Clause [<field name>] conflicts with GROUP BY clause.

is generated if you have multiple group headers and the numeric group header is the outermost group.

REFERENCES

For more information about the Microsoft Access version 2.0 Service Pack, please see the following article in the Microsoft Knowledge Base:

Q122927 WX1124: Microsoft Access Version 2.0 Service Pack

Additional query words: gpf jet25 jet 2.5

Keywords : kberrmsg kbusage RptSort
Version : 2.0
Platform : WINDOWS
Issue type : kbbug