Microsoft KB Archive/134622

= Crash or Query Lost after "Division By Zero" Error =

Article ID: 134622

Article Last Modified on 8/19/2003

-

APPLIES TO


 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q134622





SYMPTOMS
In Microsoft Query, when you edit your query and enter the value zero (0) in a record in your database, you may receive the following error message:

Division by zero

When you click OK, one of the following symptoms may occur:

Microsoft Query version 1.0

 * The data in your query disappears from the Data pane -or-


 * You receive a general protection (GP) fault in module MSQUERY.EXE



CAUSE
This problem occurs when you enter the value zero in a column in your query that is being used as the denominator in a division operation in a field expression. For example, if you create an expression for a field in your query, such as Field1/Field2, you may receive the results described above if you then enter the value zero in the Field2 column.

By design, you receive the "Division by zero" error message whenever you enter a value or expression in your query that causes the value zero to be used in the denominator of an expression. However, if you create the division expression for a field, and you then edit your data so that the value zero is used as the denominator in the expression, your query data may disappear from the Data pane following the "Division by zero" error message.

Additionally, if you create the division expression for a field from an existing expression, and you then edit your data so that the value zero is used as the denominator in the expression, you may receive a GP fault in addition to the "Division by zero" error message.



RESOLUTION
To avoid this problem, do not add the value zero to a record in your database if the column that contains this value is being used as the denominator in an expression for a field.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 1.00 gpf dbase MSQUERY

Keywords: KB134622

-

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

© Microsoft Corporation. All rights reserved.