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

    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
    Location
    One Flump in One Place
    Posts
    14,912
    Use your numbers table (or create one if you don't have one). One column of integers, numbers running from 0 up to whatever.

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

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

  4. #4
    Join Date
    Jul 2012
    Posts
    1

    Amortization

    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
  •