Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access General
How to Avoid Dividing by 0 errors in query
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jason52, post: 1011573"] 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. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access General
How to Avoid Dividing by 0 errors in query
Top
