IIF

I have a simple IIF that just will not work. It throws the ") expected" error.

What I think should work: IIF( valueA > valueB, "true", "false")

I have tried:

[IIF( valueA > valueB, "true", "false")]

IIF( valueA > valueB; "true", "false")

[IIF( valueA > valueB; "true", "false")]

Nothing seems to work on this very basic attempt.

HELP!

Michael

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 7:40PM
    it needs to be
    [IIF( (valueA > valueB); "true", "false")]

Leave a Comment