Hopefully I posted this question in the correct location.
I am using Access 2013 and have a database built for tracking assets. I have been asked to report back to board on our assets with current values. I have Acquired Date, Purchase Price, Current Value, Yearly Depreciation, Salvage Value, and Usage fields that I think I need to use to calculate this. I have the Depreciation working using the Built-In->Financial->SLN calculating the yearly straight line depreciation value. I am wondering if there is a expression I could use that would put in the current value field the correct value from taking purchase price and minus the depreciation value * time elapsed to current date or at least current year and show that current value in the correct field on the form. As I said the Depreciation is working with the Calculated Data Type.