#num!

I am trying to null out any field that a #num! appears in. I have tried all
the solutions posted so far and can find none to help. The fields are date
fields link to an excel sheet. the error occurs anywhere the input field is
blank. However, the cell in excel actually contains a if() statement that
copies in a value or "". What I am trying to do is write a query that looks
for the #num! and replace it with a null.
The last code I tried was
GD: IIf([CPAP_APD]0 And Not IsNull([cpap_APD]),[cpap_apd],Null)
The date comes over great, but where the error occurs, the error #num!
carries over.

Please help, this is time sensative and I have been trying to solve it for
several days now.

Thanks

The first thing I'd try is to get rid of the #NUM errors in Excel. Try
using the ISERROR in an IF formula, like

=IF(ISERROR(myformula), "", myformula)

Rob

DDBeards wrote:
I am trying to null out any field that a #num! appears in. I have tried all
the solutions posted so far and can find none to help. The fields are date
fields link to an excel sheet. the error occurs anywhere the input field is
blank. However, the cell in excel actually contains a if() statement that
copies in a value or "". What I am trying to do is write a query that looks
for the #num! and replace it with a null.
The last code I tried was
GD: IIf([CPAP_APD]0 And Not IsNull([cpap_APD]),[cpap_apd],Null)
The date comes over great, but where the error occurs, the error #num!
carries over.

Please help, this is time sensative and I have been trying to solve it for
several days now.

Thanks