How do I Create a Loan Amortization Schedule in MS Access with VBA RRS feed

  • Question

  • I have a Form called ScheduleF based on a table called ScheduleT with the following fields

    • Client Name
    • Principal
    • Period
    • Payment frequency(user have to select daily, weekly or monthly)
    • Loan Beginning Date
    • Expected Loan Completion date
    • Payment

    What I want to do is to generate a loan amortization Schedule for each Client so that payment is spread for them based on their payment frequency.

    I have been searching for solution for weeks now to no avail

    I'm really stuck! I need help with this code.

    Saturday, August 24, 2013 12:45 PM