Hello,
This project is for editing an existing asp script that allows us to add/edit & delete data from an access database.
What we need is for the script to be edited to be able to do auto calculations in specific columns.
You may view the script at: [login to view URL] [username=login pass=pass]
auto calculations needed:
1. % Diff .....(Actual - Forecast) / Forecast
ex) (5862 - 9900) / 9900 = - 40.8%
2. % Extra..... Additional Secured / Committed Capacity
ex) 2000 / 16000 = 12.5 %
3. Total Capacity kgs......Additional Secured + Committed Capacity
ex) 16000 + 2000 = 18,000
4. % Actual Uplift vs Ttl Cap....Actual / Total Capacity
ex) 5862 / 18,000 = 32.6 %
Please feel free to suggest a better solutions.
Thanks and hope to hear from you guys sson!
P.S. I can send you the asp files if needed.