Advice on direction of finance query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a report that shows the payments of an amortization database. I want
the query to show all payments for each year up until the loan is paid
(principal field is equal to 0). I want the computer to calculate it
automatically. I have already got the database to calculate the PMT and the
end date of the loan based on a first date.

Any advise on direction to go with this? Any particular format that would
be easier to generate?
 
The method that I have used in the past is to create a temporary table with
a record for each payment.
 
Back
Top