I have a query where the source table occasionally has missing data. This is normal. The query returns #Error where the data would normally be if it were present in the source. I have tried using the IIF function to force the #Error to a value of "0" with no luck. No matter what i do to try and convert the #Error to something else it always returns #Error. I also tried the Replace function and it still returns #Error. Can someone lend me some insight into what may be causing this. I am so close to finishing this part of the database yet this issue has brought me to a halt.
Thank you,
Brian
Thank you,
Brian