IIF with wildcard and OR...

[NWO]

Hi.

Here is my statement:

Class: IIf([T_Class_Preference] Like "E1*","1st Preference") Or
IIf([T_CLass_Preference] Like "E2*","2st Preference")

Now the first IIF works just fine, but I want to use the same logic with
"E2*" and "E3@", but when I add the second IIF statement, I get -1 in the
Class field on the result query screen. So, how do I put this together to
get the desired results based on three desired conditions? No code please.

Thank you

Mark

 

[Ken Snell [MVP]]

Class: IIf([T_Class_Preference] Like "E1*","1st Preference",
IIf([T_CLass_Preference] Like "E2*","2nd
Preference",IIf([T_CLass_Preference] Like E3@,"3rd Preference")))
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/