problem with IF THEN statement in access 2003 query

[sfgiantsdude]

Trying to figure out what I'm doing wrong with this IF THEN statement that I am trying to use in a query.



Expr4: Iif(([MCA_EPM_ISSUES]![QTR])="4",“TEST”,“ “)

In this case, the "QTR" field is designated as a text field in the design view of the table "MCA_EPM_ISSUES".

Any suggestions?

[June7]

What is wrong - error message, wrong results, nothing happens? I assume the table is included in the query. Show the SQL statement. If QTR is not =4 you want an empty string or a space? My practice is to return Null.

[sfgiantsdude]

It says invalid syntax. "You may have entered an operand without an operator. The table is included in the query.

[June7]

Aside from unnecessary set of parens and funny-looking quote marks, don't see anything wrong. I copy/pasted your expression into a query. It has issue with the quote marks. I have encountered this before. Try completely retyping the expression.

Iif(([MCA_EPM_ISSUES]![QTR])="4","TEST","")
Note no space between the last quote pair.

or

Iif(([MCA_EPM_ISSUES]![QTR])="4","TEST",Null)

[sfgiantsdude]

Thanks very much!