MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 16:25
- Joined
- Feb 5, 2019
- Messages
- 299
Hi All,
I am working on a quantity price break query and wondered if there is a an easy way for the below.
I will have 8 breaks of 1, 2, 5, 10, 25, 50, 100, 250. I would like the expression to take the QuoteQuantity (IE 32) and quickly find where that sits in the price breaks. As in >25 AND < 50
In the past I have used nested IIf statements but I am hoping there is a better way.
~Matt
I am working on a quantity price break query and wondered if there is a an easy way for the below.
I will have 8 breaks of 1, 2, 5, 10, 25, 50, 100, 250. I would like the expression to take the QuoteQuantity (IE 32) and quickly find where that sits in the price breaks. As in >25 AND < 50
In the past I have used nested IIf statements but I am hoping there is a better way.
~Matt