IIF Help

[Gootz11]

Hello everyone,
I have the following IIF statement in a querie and in returns an error for ever record.

REC: IIf([count1diff]>=[trigger],"YES",IIf([count1diff]<[trigger],"NO"))

any idea of what i am doing wrong???

Thanks in advance for the help!

JG

 

[WayneRyan]

JG,

Iif(Condition, IfTrue, IfFalse)

Try:

REC: IIf([count1diff] >= [trigger], "YES", "NO")

Wayne

 

[raskew]

Hi -

Take a look in the help file. An Iif() statement has a true and a false portion. It's not necessary--and in fact mucks-up the statement--to repeat the iif().

To illustrate, try this:

IIf([count1diff]>=[trigger],"YES","NO")

If the statement is true, it returns "Yes", otherwise it returns "No".

HTH - Bob