Quantity

[Chrisopia]

ok, so I created a table with headings: QTY boundries and Price per QTY.

Basically I'm trying to create a price calculation, but I cant work out how to create it.

Price boundries, for example; 1-20 @ 10p each, 21-50 @ 8p each, etc...

how would I work out a price on the qty which will be entered into a box in a form??

 

[FoFa]

Consider either something like a combobox to select the price boundry.
Or if you want to base it off an entered quantity, how about qtylow and qtyhigh fields instead? Then a simple between or >= and <=.
Of course if you qtys are tied to a specific product, you could always get the max where the qty < qty boundry and product# = qtyproduct#

Guess it depends on how you want it to function.