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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with Access programming, Depreciation
- Thread starter RandDsnow
- Start date
Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
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
Andrew
Upvote
0
Excel Facts
Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Similar threads
- Solved
