Microsoft Access xpression Builder

28-04-2018 à 15:21:09
Hello,

I have built a asset in the database and I have been able to use it for the future. I have fields in the DB with Acquired Date, Purchase Price, Usage (Useful life of item), Depreciation Value, Current Value and Salvage Value. I am trying to figure out if it is a built-in formula for the current value of the value of the current value. I can see in the built-in functions that there is a financial-> SLN which will give me the yearly depreciation but want to fill in the current value with what it is. The Salvage value should be $ 0.00 on all our assets, 

For more details:
3D Walkthrough Video

Thanks