Hi there,
I'm creating a nested Iff statement in a query to return the corresponding cost for each value:
0-500 = 6,48
501-750 = 4,32
751+ = 2,16
2,16 displays correctly for values over 751.
4,32 displays correctly for values 501-750
6,48 displays correctly for values 0-500. HOWEVER! Amongst the 6,48 output, there are values that should have been caught in the over 751 value region (2,16), for example numbers such as '1170', etc. Below is my statement:
Cost: IIf([Value]>="0" And [Value]<="500","6,48",IIf([Value]>="501" And [Value]<="750","4,32",IIf([Value]>="751","2,16",Null)))
If anyone could help in any way would be very appreciated, I am very unsure as to why some of the values that should be in the 2,16 (over 751) are in the 6,48. Thank you!
I'm creating a nested Iff statement in a query to return the corresponding cost for each value:
0-500 = 6,48
501-750 = 4,32
751+ = 2,16
2,16 displays correctly for values over 751.
4,32 displays correctly for values 501-750
6,48 displays correctly for values 0-500. HOWEVER! Amongst the 6,48 output, there are values that should have been caught in the over 751 value region (2,16), for example numbers such as '1170', etc. Below is my statement:
Cost: IIf([Value]>="0" And [Value]<="500","6,48",IIf([Value]>="501" And [Value]<="750","4,32",IIf([Value]>="751","2,16",Null)))
If anyone could help in any way would be very appreciated, I am very unsure as to why some of the values that should be in the 2,16 (over 751) are in the 6,48. Thank you!