Software

Ask something
Discussion Locked

Calulating Depreciation in Access 2000

0 helpful
1 reply

by dj_yorkie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by richtee

It would be helpful if you would re-submit your question with clarification.

It is not clear which fields you already have the data and/or calculations for and which you need help with. Not sure if you need help with the calculation or with storing the results.

This discussion is closed to new replies.