IIF with wildcard and OR...

N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

joining two iif statements 2
Busted IIf function 3
Joining IIF statements together 2
iif, or, else? 3
Multiple iif challenge 2
IIF stmt in Criteria 3
iif and between 2
IIF statement in query criteria, help! 3

Top