I've set up a database that tracks leasing activity for an office property.
There is a Leases table for basic lease terms and then a related Rents table. When a lease is signed, there may be several rent increases built into it. So the records for Rents would specify a date and a rent amount.
I'd like to create a report that projects rent income for the next year. Basically each column is a month and each row is a Lease, and Access would fill in the rent amount for that month for based on the current Rents record. Is there a way to do this? Seems like it would be an obvious function for any property management database. But I'm not coming up with anything.
Thanks in advance!