Version 2.1 update (2024-09-12). Fixed the filter boxes so that if you pick "life of loan" and there is a payment made before the loan start date or after the last scheduled payment, it will still adjust accordingly. Also fixed the manual mode so it will not automatically change to the loan scheduled payment dates.

If you've purchased this template, you can download the new version here: Access Amortization Template v2

If you've made extensive changes to your database, the only modifications I've made are in the GlobalMod, so you don't have to worry about updates to your forms or reports.

Thanks to Donald Lader for catching this bug. I would have never encountered this bug myself because I would have never paid on a loan before the first payment was due (but I get how a down payment might be logged this way). And most loans are 10+ years, so we probably wouldn't have encountered the end-date bug until then. LOL.