How to Avoid Dividing by 0 errors in query

J

Jason52

I have been getting 'Overflow' errors when trying to run a query. I found
out it is because some of my data has a divisor of 0 (e.g. 10/0). This data
comes from linked Excel worksheets with hundreds of rows of data. Is there
an IF statement or something I can add to the query in the dividing column
that can just return a blank (instead of the #Error)? I need this query to
feed into another query that I am getting the 'Overflow' error on.
 

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

Unique values divide by zero error 1
Access Query to import from Sharepoint 0
Help on Code Snippet Error {Val function} 6
Error on Access Query 10
"Overflow" error on SELECT query 5
reporting even though a calculation made is dividing by zero 14
Workaround: Divided by 0 error 2
Overflow Error message 5

Top