Multiple conditions

[Guest]

I have a number of different conditions which yield the same result. I tried
(what I thought was) a straightforward IIF statement

IIF ( [ABC List] like ( "AB*" or "CD*" or "EF*" ), "ABC","")

But that didn't give me results. (When any of those conditions was met, I
got a blank.) So instead I did the following.

IIF ( [ABC List] like "AB*", "ABC", IIF ( [ABC List] like "CD*", "ABC", IIF
( [ABC List] like "EF*", "ABC","")))

This works, but it's very unwieldy. Is there a way to construct the query
more like the first one above?

 

[Guest]

Instead of the nested iif, use the criteria with Or

IIF([ABC List] like "AB*" Or [ABC List] like "CD*" Or [ABC List] like
"EF*" , "ABC","")

 

[Guest]

Thanks so much Ofer and Shabbat Shalom!

David

Instead of the nested iif, use the criteria with Or

IIF([ABC List] like "AB*" Or [ABC List] like "CD*" Or [ABC List] like
"EF*" , "ABC","")

--
Good Luck
BS"D

I have a number of different conditions which yield the same result. I tried
(what I thought was) a straightforward IIF statement

IIF ( [ABC List] like ( "AB*" or "CD*" or "EF*" ), "ABC","")

But that didn't give me results. (When any of those conditions was met, I
got a blank.) So instead I did the following.

IIF ( [ABC List] like "AB*", "ABC", IIF ( [ABC List] like "CD*", "ABC", IIF
( [ABC List] like "EF*", "ABC","")))

This works, but it's very unwieldy. Is there a way to construct the query
more like the first one above?

 

[Guest]

Shabat Shalom

--
Good Luck
BS"D

Thanks so much Ofer and Shabbat Shalom!

David

Instead of the nested iif, use the criteria with Or

IIF([ABC List] like "AB*" Or [ABC List] like "CD*" Or [ABC List] like
"EF*" , "ABC","")

--
Good Luck
BS"D

I have a number of different conditions which yield the same result. I tried
(what I thought was) a straightforward IIF statement

IIF ( [ABC List] like ( "AB*" or "CD*" or "EF*" ), "ABC","")

But that didn't give me results. (When any of those conditions was met, I
got a blank.) So instead I did the following.

IIF ( [ABC List] like "AB*", "ABC", IIF ( [ABC List] like "CD*", "ABC", IIF
( [ABC List] like "EF*", "ABC","")))

This works, but it's very unwieldy. Is there a way to construct the query
more like the first one above?