field statement with if then else

[JoeM]

That means it does not recognize the field name. That usually means you are trying to reference a field that does not exist or you have a typo in your field name.

[cwagenaar]

I think you may simply have too many parentheses. Most Iif functions look more like this:

Iif(expression,truepart,falsepart).

You shouldn't need parentheses around the expression, the truepart, and the falsepart, respectively, but parentheses to enclose all three together.

[JoeM]

I think you may simply have too many parentheses.

You would get a syntax error in that instance, not a parameter box.

[cwagenaar]

That's true, my mistake.