hi everyone, i am setting up my own database application using access for my loans and i want it to automatically calculate different payment schedules according to different terms of payment. like 1 month, 2 months, 3 months and so on up to 12 monthly terms and the corresponding amount dues. is this possible? here's an example:
let's say i have a transaction dated February 15, 2009 and borrowed $5,000 that would be divided into 5 equal payments in 5 months, can access automatically calculate the subsequent payment dates per month if the 1st due date is scheduled on the 15th of march with the amount of $1,000 and so on..
i've created a table with these fields
TransactionId TransactionDate Amount Term
100 15-Feb-10 5000 5
aside from this i want access to automatically display the different pay dates and amount due. like this