iif Statement Help

[smc678]

Is it possible to use an iif statement in a query iff= [STAT_CODE] =30 then say putaway and iff [STAT_CODE]= 50 then say allocated and iff [STAT_CODE]= 40 then say not allocated.

[RuralGuy]

That is nesting IIF's and perfectly legal up to 7 levels. Have you tried it yet?

[smc678]

I havent, How would you write that?

[RuralGuy]

What do you want returned if the [STAT_CODE] is not equal to 30, 40 or 50? Is the [STAT_CODE] field Numeric or Text?

[smc678]

Null, and its a number in the table

[RuralGuy]

So you have a Numeric field that contains a Null until you put something in it?

Will the [STAT_CODE] field ever have a value other than 30, 40, 50 or Null?

[June7]

Try:

IIf([STAT_CODE]=50, "allocated", IIf [STAT_CODE]=40, "not allocated", "unknown"))