using IIF with And and Or

[GeorgeB]

Hello

I searched a lot and I couldn't find what I am looking for

I am trying to combine IIF function with And and Or and I started my first query but it doesn't work and I can't figure out why

if you can please help me or provide some links to help with having many conditions in iif

I am still new and only use the code builder no idea on SQL




Case1: IIf(([CountOfORDER_NUMBER]=1) And (([CPU_TYPE]="*sae*") Or ([CPU_TYPE]="*preliminary*")) And (([WO_STATUS]="dlp" or [WO_STATUS]="fc")),"N","")


Thanks very much



Additional info :

What I want to is

if [CountOfORDER_NUMBER]=1
And [CPU_TYPE]="*sae*" OR = "*Pre*"
And [WO_STATUS]="dlp" or "fc"

I just get any indicator otherwise I don't care

but that's the first and easiest case

[recyan]

And [CPU_TYPE]="*sae*" OR = "*Pre*"

Do you have [CPU_TYPE] values stored the way you have shown i.e. *sae*, *Pre* or are you trying to find values similar to sae or Pre.

If you are trying to find similar values, try

..........
And 
(
    [CPU_TYPE] LIKE "*sae*" 
    Or 
     [CPU_TYPE] LIKE "*pre*"
) 
And  
.............

Thanks

[GeorgeB]

you are a legend

Thanks very much

[recyan]

Glad you found it helpful.
In case you have not seen this, just take a look :
http://office.microsoft.com/en-us/ac...001032253.aspx

Thanks