G Guest Sep 6, 2007 #1 I get an "Overflow" error when i try to do simple division. Is there any way to troubleshoot the error?
I get an "Overflow" error when i try to do simple division. Is there any way to troubleshoot the error?
D Dirk Goldgar Sep 6, 2007 #2 In Chris said: I get an "Overflow" error when i try to do simple division. Is there any way to troubleshoot the error? Click to expand... Please show the line of code, and state the data types of all variables involved in the operation.
In Chris said: I get an "Overflow" error when i try to do simple division. Is there any way to troubleshoot the error? Click to expand... Please show the line of code, and state the data types of all variables involved in the operation.
G George Nicholson Sep 6, 2007 #3 Be sure to avoid division by zero. It can cause Overflow errors in queries. iif(x = 0, 0, y/x) HTH,
G Guest Sep 6, 2007 #4 Thanks for the responses. I put in the Iif logic and that was the fix. Thanks!
