Repeat query

[Guest]

Hello Group,

I'm trying to create a query that repeats numerous of times.

Example:

I have a loan for 250,000.00
Interest 7%
Month 120
Start Date 2/1/2005

I want the query to be able to start applying the principle and interest on
the start date. Then every month after the start date the result of the
principle and interest for each month until the loan is paid off.

 

[Guest]

Hi,
sounds like you will need to use a do loop.

 

[John Vinson]

Hello Group,

I'm trying to create a query that repeats numerous of times.

Example:

I have a loan for 250,000.00
Interest 7%
Month 120
Start Date 2/1/2005

I want the query to be able to start applying the principle and interest on
the start date. Then every month after the start date the result of the
principle and interest for each month until the loan is paid off.

I'd suggest doing this in Excel, for one thing - it's got a builtin
loan amortization function that's very easy to use!

If you wish to do it in Access, though, I'd use ONE query run ONCE,
not the same query multiple times. You can do this with the help of a
small auxiliary table Num with one field N; fill it with values from 0
to the maximum number of months you're likely ever to want. Create a
query on Num using your expression for the present value, using N as
the month; use a criterion on N to limit the number of months.

John W. Vinson[MVP]