Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010

    Question Unanswered: Monthly Amortization

    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

    TransactionID DueDate AmountDue
    100 15-mar-10 1000
    100 15-apr-10 1000
    100 15-may-10 1000
    100 15-jun-10 1000
    100 15-jul-10 1000

    if the Term Field is set, let's say to 8, it would calculate 8 different due dates and divide the amout to 8 payments.
    is this possible?
    thank you for your help in advance!!!

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Use your numbers table (or create one if you don't have one). One column of integers, numbers running from 0 up to whatever.

    SELECT TransactionID, DATEADD("m", numbers.number, DueDate), AmountDue
    FROM myTable, numbers
    WHERE numbers.number BETWEEN 0 AND 12
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2010
    thank you very much for your help! Godbless

  4. #4
    Join Date
    Jul 2012


    how did you do it? i tried it but the number is fixed.....
    Last edited by gelocons; 06-14-14 at 07:45.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts