Depreciation Table possible in Access?

[aarotech]

I have this depriciation table in excel, I use it with the year and the life of the asset to find the depreciation percentage.

works great in excel need to be able some how to do this from within access 2010.

Please help!



attached is the excel file

[Rod]

I cannot devise a straightforward formula so the percentages would have to be encoded in a table. Presumably if there is no entry in the table then the rate is 20%. The table would look something like the following.

Age (in years) - you term this effective year.
Depreciation Scheme
Percentage

The VBA code would be something like

Pct = DLookUp("Percentage","Mytable","Age = " & myage & " AND DScheme = " & myscheme)
Pct = Nz(Pct,0.2)

[aarotech]

Thank you very much, working on it will let you know.