theconfusedbear
Registered User.
- Local time
- Today, 17:40
- Joined
- Oct 12, 2006
- Messages
- 18
How can you create a dropdown field with 20% through to 30% so that the prices increase by that amount?
Add Percentage Rate on Prices
- Thread starter theconfusedbear
- Start date
DCrake
Remembered
- Local time
- Today, 17:40
- Joined
- Jun 8, 2005
- Messages
- 8,626
Create a table with 11 numbers 1.0,1.2,1.21,1.23,1.24 ...... 1.3
Add this table to a query along with the table that has the prices in. DO NOT join the tables
Add the price in one column and in another column add [Price]*[Increase] where Increase is the percentage increase. This will give you a price times the value. Having 1.0 will give you the actual price.
Add this table to a query along with the table that has the prices in. DO NOT join the tables
Add the price in one column and in another column add [Price]*[Increase] where Increase is the percentage increase. This will give you a price times the value. Having 1.0 will give you the actual price.
theconfusedbear
Registered User.
- Local time
- Today, 17:40
- Joined
- Oct 12, 2006
- Messages
- 18
You see thats why your clever!!! thank you!
- Local time
- Today, 17:40
- Joined
- Sep 12, 2006
- Messages
- 16,052
watch out though - increasing values by %ages may leave you with hidden decimals waiting to spring errors on you.
eg a price of £1.50 increased by 10% is £1.65
a price of £1.55 increased by 10% is £1.705.
this may DISPLAY as 1.70 (or even 1.71) - but it STILL IS 1.705 and when you use it in calculations you may get unexpected differences as a result.
eg a price of £1.50 increased by 10% is £1.65
a price of £1.55 increased by 10% is £1.705.
this may DISPLAY as 1.70 (or even 1.71) - but it STILL IS 1.705 and when you use it in calculations you may get unexpected differences as a result.
