I have got a problem. I need to calculate depreciation on certain assets in an Asset Tracking DB.
The user will input the ‘From’ and ‘To’ dates for the calculation, from which the amount of days for depreciation is calculated. Data will be taken from the following fields:
– Type of asset (text value, only ‘purchased’ assets need depreciation calculating for them)
– Written Down Value of asset(money value that starts off with asset’s purchase cost)
– Depreciation Method (a text value that tells the calculation which method of depreciation to use)
The calculation then needs put values in these fields:
– Written down value (subtract result from the value stored here)
– Date Depreciation last run (‘To’ date input by user)
– Depreciation year to date + Depreciation life to date (adding result of depreciation to existing value)
Also, would like to prompt to print off a report of all records changed.
Any help would be EXTREMELY grateful!
Thanks, Craig Watson