Nested IIF

[Oldie]

Hi,
I'm trying to create a nested iif statement for a price list I have. In the list it has Part #, Qty1 Price1, Qty2 Price2, Qty3 Price3 and so on. Not all the Price columns are filled, may not have a price until we meet Qty4 so I need the query to find the fist avail price, so if no price in price1 use price2, if nor price in price2, use price3 and so on, to price5, I'm not concerned with the qty's as I have that sorted
I have tried IIF(Isnull([Price1]),[Price2],IIF(Isnull([Price2]),[Price3],IIF(Isnull([Price3]),[Price4],[Price1])))

Any help or suggestions would be appreciated.
Regards Oldie (but still a goodie)

[Aragan]

use the Switch function:

The syntax for the Switch function is:

Switch ( expression1, value1, expression2, value2, ... expression_n, value_n )

expression1, expression2, expression_n is a list of expressions that are evaluated. The Switch function is looking for the first expression that evaluates to TRUE.
value1, value2, ... value_n is a list of values. The Switch function will return the value associated with the first expression that evaluates to TRUE.