Access 97 Overrun Error

S

SInouye

Anybody have a solution for the following problem?
I have a query QUERY_B that averages about 50 different
fields from another query QUERY_A that gets its data from a
table TABLE_A. Some of the fields in QUERY_A are
calculated (multiply or divide only). The problem I am
encountering is where a muliplication or division
calculation requires a multiplier or divisor of zero. When
this happens, QUERY_A computes the number which it shows as
zero, but QUERY_B won't run. It just gives an "OVERRUN"
error message.

Any solutions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A useful AVERAGE calculation without using the built-in AVERAGE function 3
Conditional Expression 5
Data Validation 1
SQL: Finding Data That Is In One Table But Not The Other 4
Non-updatable record set 6
Exporting access report to excel-Error message 2
Access #Error in calculated field 1
Overflow error 2

Top