Overflow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get an "Overflow" error when i try to do simple division. Is there any way
to troubleshoot the error?
 
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.
 
Be sure to avoid division by zero. It can cause Overflow errors in queries.

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


HTH,
 

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

Overflow Error 5
Overflow Error 1
How to Avoid Dividing by 0 errors in query 1
Help on Code Snippet Error {Val function} 6
What is does "overflow" warning mean when trying to run a report? 2
Why am I getting an overflow error in this simple query? 3
Numeric Overflow Error 4
Overflow error when appending data to SQL from Access 1

Back
Top