Using Iif and Between

[razorking]

Being stupid yest again, Have been searching the net and trying to figure it out but...am spending to much time with no good results. Hope someone here can give me a clue.

I have numerical values in a table of a field. I need to display results in a query something like this, using a new field based upon a field called - PRICE
If price >0 - A
If Price >5 - B
If Price >10 - C
If Price >15 - D

Assumimg there is a way to do this using an Iif but not sure who to write it.

Thanks!

 

[Banana]

This thread has what you are looking.

 

[EMP]

Expr1: IIf(Price<=5,"A", IIf(Price<=10,"B", IIf(Price<=15,"C", "D")))


If Price may be Null,

Expr1: IIf(IsNull(Price),Null, IIf(Price<=5,"A", IIf(Price<=10,"B", IIf(Price<=15,"C", "D"))))

^

 

[razorking]

Expr1: IIf(Price<=5,"A", IIf(Price<=10,"B", IIf(Price<=15,"C", "D")))


If Price may be Null,

Expr1: IIf(IsNull(Price),Null, IIf(Price<=5,"A", IIf(Price<=10,"B", IIf(Price<=15,"C", "D"))))

^

That works, thank you very much EMP...very much appreciated.

That saves me some time