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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create amortization schedule 0
Creating an update query that uses multiple parameters 2
Cutting excess rows 2
Left Join 2
Problem querying table linked ODBC Database 2
CUMIPMT 0
query speed 5
APR calculation for Mortgages with a balloon payment. 6

Back
Top