ID: Q134622
1.00 WINDOWS kbtool
The information in this article applies to:
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
-or-
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.
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.
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.
KBCategory: kbtool KBSubcategory: xlquery
Additional reference words: 1.00 gpf dbase
Keywords : xlquery
Version : 1.00
Platform : WINDOWSLast Reviewed: September 15, 1996