G
Guest
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.
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.