Overflow

[Chris]

I get an "Overflow" error when i try to do simple division. Is there any way
to troubleshoot the error?

 

[Dirk Goldgar]

In

I get an "Overflow" error when i try to do simple division. Is there
any way to troubleshoot the error?

Please show the line of code, and state the data types of all variables
involved in the operation.

 

[George Nicholson]

Be sure to avoid division by zero. It can cause Overflow errors in queries.

iif(x = 0, 0, y/x)


HTH,

 

[Chris]

Thanks for the responses. I put in the Iif logic and that was the fix.
Thanks!