IIF HELP

[Gootz11]

Hello,
I have the following IIF statement but i keep getting an #error. any ideas what i am doing wrong?
Thanks
JG

REC: IIf([adj]>=[trigger],&quot;YES&quot;,IIf([adj]<[trigger],&quot;NO&quot)

I even tried this and still keep getting an error.

REC2: IIf([adj]>=[trigger],&quot;YES&quot;,&quot;NO&quot

Thanks in advance

JG

 

[hneal98]

What error are you getting?

 

[Gootz11]

I'm getting a #Error
thanks

 

[hneal98]

Oh. Sorry. That usually means Access is not recognizing one of the fields. Make sure you have spelled everything correctly.

 

[JonFer]

The correct IIf function is the one for REC2. You can get the #Error if one of the values is Null. Try this:

IIf(nz([Adj],0)>nz([trigger],0),&quot;Yes&quot;,&quot;No&quot

The nz() converts Nulls to whatever you indicate with the second parameter. You may want to use something other than zero for your query.