I recently asked for help in finding a database template for tracking the depreciation of assets
This one from Microsoft:
seems to be pretty good, but it appears that I'd have to enter each month's depreciation amount for any new asset I add. The depreciation table has 3 fields (besides the unique ID): Asset ID, Depreciation Date, and Depreciation Amt. Unless I'm reading it wrong, if I were to add a new asset that had a 1-year depreciation life and was worth $1200, I'd have to create 12 entries depreciating $100. Is there some VBA script that I can write that will add the records automatically? Something like a for loop that adds (12*depreciation years) records?