Iff with multiple results?

[monkeyman]

Hi all,



I have to show a value "shipping cost" in a query field based on the weight of product in field "weight". Can you do this with an Iff Statement or does that only handle true/false criteria?

Weight = <.8lbs, Shipping Cost - $5.95
Weight = >.81lbs and <2 lbs, Shipping Cost - $7.95
About 5 tiers more like this.

I know I can make a field in the table for weight, but since we sometimes change shipping costs, I'd rather this be real time through a query.

Can anyone offer suggestions on how to pull this off? Thanks in advance!

[pbaldy]

You can nest one IIf() within another, or you might find Switch() more appropriate.