G
Geoffrey Bolton via AccessMonster.com
Ok let?s see if I can make this understandable. I have a database that
tracks rents by month. To do this I have created a table that has the rent
amount for each month in the life of a lease and the rent amount due.
Address / Due Date / Rent
1234 howard / 1/1/02 / 1200
1234 howard / 2/1/02 / 1200
1234 howard / 3/1/02 / 1400
1234 howard / 4/1/02 / 1500
5555 smith / 2/20/04 / 2550
5555 smith / 3/20/04 / 2550
As you can see from the short example above the rents change per the lease
agreements.
What I would really like is to build a form that would ask you for the
start date, the date of each rent rate change and the end date and rent
amounts for each period and then have it fill in all the months between
each rent change.
I am not a good Access guy, learned what I know from reading the help
menus, so please if possible keep it simple.
tracks rents by month. To do this I have created a table that has the rent
amount for each month in the life of a lease and the rent amount due.
Address / Due Date / Rent
1234 howard / 1/1/02 / 1200
1234 howard / 2/1/02 / 1200
1234 howard / 3/1/02 / 1400
1234 howard / 4/1/02 / 1500
5555 smith / 2/20/04 / 2550
5555 smith / 3/20/04 / 2550
As you can see from the short example above the rents change per the lease
agreements.
What I would really like is to build a form that would ask you for the
start date, the date of each rent rate change and the end date and rent
amounts for each period and then have it fill in all the months between
each rent change.
I am not a good Access guy, learned what I know from reading the help
menus, so please if possible keep it simple.