Using IIF and OR

[Jackcess]

Hi, I am trying to do the following in a query.

If X equals A, B, or C, then return True, otherwise False.

I've tried using the following syntax but can't seem to get it right:

iif(x=A OR x=B OR x=C, "True","False)

Any advice? Thanks!

Jack

 

[Zonie32]

Status: IIf([X]="a",True,False) Or IIf([X]="b",True,False) Or IIf([X]="c",True,False)

 

[bosk00]

You can also nest the IIF's

Status: IIf([X]="a",True,(If([X]="b",True,(IIf([X]="c",True,False)))))

Alan
Senility at its finest

 

[Jackcess]

Thanks! That worked.

 

[PHV]

And the simplest:
[tt]IIf(x='A' OR x='B' OR x='C', True, False)[/tt]
Or even simpler:
[tt](x='A' OR x='B' OR x='C')[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[linsk33]

A follow-up question: I'm trying to do the same query but need to use a wildcard, in other words my fields aren't just filled with A or B and C but with A01 or A19 or B01 or B02, etc. I thought the asterisk would work as a wildcard, i.e.:

IIf(x='A*' OR x='B*' OR x='C*', True, False)

... but the results are not identifying any records as meeting the condition.

What am I missing?

Rick

 

[Jackcess]

linsk33,

try using the LIKE instead of =

for example,

iif(name like 'A*', "Apple","Banana")

I used it once and it worked. i might have the syntax above a bit screwy though.

 

[r937]

for the original problem, i prefer the even simpler simpler

iif(x in ('A','B','C'),true,false)

for the LIKE problem you have to spell them out

iif(x like 'A*' 
 or x like 'B*' 
 or x like 'C*',true,false)

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[PHV]

Another way:
IIf(x Like '[ABC]*', True, False)
Or:
(x Like '[ABC]*')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244