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.
MH - 30 Apr 2007 22:35 GMT
Iif([Divisor]=0,0,[MyField]/[Divisor])
MH
>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
[quoted text clipped - 5 lines]
> to
> feed into another query that I am getting the 'Overflow' error on.