Overflow error when performing calculations

[Guest]

Hi,

I am getting an overflow error when performing some calcuations in a query
that I an running. Any idea how to isolate why this is happening?

Thanks,

Chuck

 

[Wolfgang Kais]

Hello "ChuckW".

Hi,

I am getting an overflow error when performing some calcuations
in a query that I an running. Any idea how to isolate why this is
happening?

First, I'd verify the formulas. (you did't post them.)
If this didn't help, I'd try to execute separate queries each
containing only one calculation. This should help in finding the
formula that produces the overflow.
Then, I'd try to idetify a row that has an overflow (use the TopValues
property of the query: First:ll recordes, then half of them ad so on
until you identify a row that produces the overflow.
Then analyze the values from the fiels used in the canculation to
reproduce the error. This should be sufficient in finding the cause.

 

[Guest]

Usually happen when there is a devision by zero.

To resolve that problem you can use IIf
IIf([Field1]=0,0,[Field2]/[Field1])

Another reason, trying to convert a value to a smaller size, like converting
a resault of 99999 to integer will resault to overflow instead convert to
doube or long