| | |
|
|
|
Price and Volume Variables |
|---|
| message from jagstirling on 5 May 2004 |
I have a general question based around the fictitous scenario below;
**************************************************
I am a confectioner selling candy and wishing to hold details of my
customers in a table.
One of the fields held is the price each customer is charged for each
type/brand of candy.
The price each customer is charged for my candy is different DEPENDANT
on three factors;
* The quantity that they buy (split into bands as below).
0-10 Items $1.00
11-20 Items $1.25
21-30 Items $1.35
* The type/brand of candy that they buy.
How can I set up my database to ensure that the right price is charged
DEPENDANT ON THE AMOUNT OF CANDY PURCHSED ?
DEPENDANT ON THE TYPE/BRAND OF CANDY PURCHSED ?
For example, if (using the info above) I typed in 9 items I would want
the price $1.00, 23 items would return a price of $1.35 etc etc etc.
In reality my quantity bands are broad so entering individual prices
for each quantity is not an option.
CAN ANYONE HELP PLEASE ?
|
|
Archived message: Price and Volume Variables (Microsoft Access Database)
