| | |
|
|
|
Price Variables Dependant on Quantity Purchsed |
|---|
| message from jagstirling on 6 May 2004 |
If I have a table of customers and the prices they are charged for a
product depending on the quantity they purchase (such as);
0-10 Items $1.00
11-20 Items $1.25
21-30 Items $1.35
How can I set up my databse to ensure the correct price is selected VIA
A QUERY when a certain qunatity is entered IN ANOTHER TABLE ?
In essence, I am trying to set a price within a given quantity band,
ie. if the quantity was 9 then the price $1.00 would be selected, the
quantity 23 then the price $1.35 would be selected.
PLEASE CAN SOMEONE GIVE ME SOME GUIDANCE ?
|
|
Archived message: Price Variables Dependant on Quantity Purchsed (MS Access Error Message)
