IIF Syntax Problem 1

[Mike555]

I'm attempting to use this as a query expression:
RemarkType: IIf([Certificate] Like "1 Obt*" Or "2 Obt*","AType","BType")

But the Like part is not working, and all records are showing as "AType".

How can I fix this? Thanks.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[JonFer]

You cannot give multiple conditions to a Like using Or - you have to use two Like statements with Or.

If([Certificate] Like "1 Obt*" Or [Certificate] Like "2 Obt*","AType","BType")

Or using the square brackets to match any of the characters between:

IIf([Certificate] Like "[12] Obt*","AType","BType")

 

[Mike555]

Thank you very much!

--
Mike

Why make it simple and efficient when it can be complex and wonderful?