Help with Access programming, Depreciation

[RandDsnow]

I'm trying to get a query, or anything in Access really, that I can enter a date and it will tell me Depreciation as of that date. I have the purchase cost and also the number of years to depreciate. I also have the depreciation amounts as of September 30, 2005, but I'm not sure if that information is helpful or just confusing my calculation. I tried to take the date entered using [EnterDate] then subtracting #9/30/2005# to get years remaining to depreciate but Assess didn't like that. Any help would be greatly appreciated. Thanks

 

[Andrew Fergus]

Thank goodness for that! (BTW that was much harder than I remembered - very taxing on the brain). How is the performance of the query once you have a lot of assets in the table?
Andrew