Hi,
I intend to increase all the prices of 5%.
For that, I'll use the 'Update Query' in Access [Price]*1,05.
But, how can I increase the prices in the tab "price" ?
For example, the price of a bottle is $5.00. But if the customer buys 4 bottles, the price will be $4.00 per bottle, and $3.00 per bottle if he buys 10 bottles.
If I use the "update Query' in Access [Price]*1,05., only the retail price increases, but not the others ( min 4, min 10)!!
How can I do to increase all the prices in the same time?
Thank you,
Bruno
I intend to increase all the prices of 5%.
For that, I'll use the 'Update Query' in Access [Price]*1,05.
But, how can I increase the prices in the tab "price" ?
For example, the price of a bottle is $5.00. But if the customer buys 4 bottles, the price will be $4.00 per bottle, and $3.00 per bottle if he buys 10 bottles.
If I use the "update Query' in Access [Price]*1,05., only the retail price increases, but not the others ( min 4, min 10)!!
How can I do to increase all the prices in the same time?
Thank you,
Bruno