IIF Statement Expression

[mjohnson1105]

Hi, I need help writing a very complex 'if statement' query expression. I need to create an alias column based on data from two data fields.

Here's the logic:

True: If [PP] = "WG" or "WS" or "WL" and If [GR] > 10 Then "Skilled" or
[GR] Between 6-9 Then "Semi - Skilled" or [GR] <6 Then "Unskilled"

False: "GS"

Any help would be greatly appreciated.


:banghead:

 

[Brianwarnock]

Iif(PP="WG" orPP="WS" or PP="WL", Iif(GR>10,"skilled",Iif(GR<6,"unskilled","semi-skilled")),"GS")

Give or take the odd typo that should be it.

Brian

 

[mjohnson1105]

Thank you Brianwarnock!!!!