SQL Query

[Guest]

My data table is like this:

Type Price1 Price2 Price3 Result
Black 2 2 3 No
Blue 2 5 6 Yes
Black 0 4 5 Yes
Red No

I am try to find an SQL query that will create the new Field "Result" based
on the following criteria:

IF Type =Black and (Price1>Price2) OR Price1=0 Return "Yes" OtherWise "No"

OR

IF Type=Blue and (Price1<Price3) OR Price1=0 Return "Yes" OtherWise "No"

OR

IF Type<>Blue OR Black Return "No"

Is this type of query possible ?

Thank You in Advance.

 

[Jason Lepack]

Expr1: IIf(Not ([Type]='Black' Or
[type]='Blue'),'No',IIf([Type]='Black',IIf([Price1]>[Price2] Or
[price1]=0,'Yes','No'),IIf([price1]<[price3] Or
[price1]=0,'Yes','No')))