If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
#num!
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 |
Thread Tools | |
Display Modes | |
|
|