#Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a query where some of the records in the TaxYear field result in #Error. Looks like:

TaxYear
2003
2003
#Error

I was hoping that using the IIf function I could write something like TaxYear2: IIf([TaxYear]="#Error",0,[TaxYear]). I just want all fields that result in #Error to return a zero (or null). How do I write the IIf function to make this work?
 
Try:

IIf(isError([TaxYear]),0,[TaxYear])

Glenn
-----Original Message-----
I've got a query where some of the records in the TaxYear
Click to expand...
field result in #Error. Looks like:
TaxYear
2003
2003
#Error

I was hoping that using the IIf function I could write
Click to expand...
something like TaxYear2: IIf([TaxYear]="#Error",0,
[TaxYear]). I just want all fields that result in #Error
to return a zero (or null). How do I write the IIf
function to make this work?
 
Back
Top