Hello dear people,
I'm kinda new to access, but wish to program a little something to let the value decrease of the inventory for our business once a year. Wonder how to set up the formula in the query. What I have:
[current value]=iif (IsNull(Year(Date())- [year of purchase]), [original value], (1-(Year(Date())- [year of purchase])/ [depreciation])* [original value])
(the year of purchase, depreciation and original value are all values already in our database)
Would love some help here
Waldo