Expression to return different values

[ps32208]

Hi,

I need to create an expression in an MS Access query to return values depending on the data in other fields, easy to achieve with IF statements in XL but new ball game in Access...

I need to achieve the following expression in a query:

If field 'Stage' has the word "Won" in part of it then return "Won" if not then if field 'Committed' = Y then return "committed" and if not then if field "Probability" >=50 then return "up" and if not then if field 'probability' <50 then return "WIP"

Any help on this is most greatfully received.

 

[Remou]

You can use IIf in Access queries:

[tt]IIf(Instr([Stage],"Won")>0,"Won",IIf([Committed]=True,"Committed",IIf([Probability]>=50,"Up","WIP")))[/tt]


Assuming that Committed is Boolean