Parameter issue.

[yeppy12]

I have an if statement that keeps giving me a parameter box that asks me to enter a C:

Expr1: IIF(IsNull(TORRY.PAF) AND (TORRY.TYPE = “C”), (TORRY.USER_DEFINED), (TORRY.PAF))

What is wrong with my if statement...is it a syntax error? I cannot figure out why the parameter box keeps popping up asking me for a "C."

 

[Jon K]

I think it's the double-quotes that you used.

You need to use "C", not “C” as seen in your code.
.

 

[yeppy12]

Ok. I'll give that a try. Thanks for the help.