Forecast Query

[D. M.]

Hello,

I have a lease database which I need to input monthly rents through the
lease term based on an annual lease figure. Example:
Lease 1 - Lease term April 1, 2005 through March 31,2008
Annual Rent: $120,000 through March 31, 2007
Increases: April 1, 2007 to $130,000 through March 31, 2008.

Is there a query that can do this for me?

Any help would be appreciated. Thanks in advance.

 

[pietlinden]

Hello,

I have a lease database which I need to input monthly rents through the
lease term based on an annual lease figure. Example:
Lease 1 - Lease term April 1, 2005 through March 31,2008
Annual Rent: $120,000 through March 31, 2007
Increases: April 1, 2007 to $130,000 through March 31, 2008.

Is there a query that can do this for me?

Any help would be appreciated. Thanks in advance.

Create a table of dates, call it LeaseDates

then use a cartesian product, eg
SELECT Lease.StartDate, Lease.EndDate, Lease.MonthlyRent
FROM Lease, LeaseDates
WHERE LeaseDates BETWEEN #4/1/2005# and #3/1/2007#
AND... {filter leases here if you need to}

Then turn that into an append query when it's logically correct and
run the insert.