Nested IIF problem

[pl456]

Maybe I have been looked at this too long. This nested IIF gives me a syntax error, maybe its wrong, I have checked else where and this is how to do it. Can anybody help/see what I am doing wrong.

expr2: IIf([expr1]=6,“6-10”,IIf([expr1]=7,"6-10",""))

 

[georgedwilkinson]

Something odd. Your " marks don't look right. Looks like you may have pasted some formatted text in. Erase the " marks and re-type them in from the query builder.

 

[pl456]

Don't you hate things like that, been sat here for ages looking at this. That did the trick, thankyou.

 

[raskew]

IIf([expr1]=6 or [expr1]=7,"6-10", "")

or

IIf([expr1] in(6,7),"6-10", "")