C
char393
I fairly new to access...be kind. I've been giving the task of creating a
form that will enable a user to input header information that will create
detail records in the database.
Basically; user will input a lease term date range and yearly lease amount
.. This term (usually 10 years) will have a scheduled increase of 5%. I need
to be able to calculate the yearly scheduled increases as detail records to
the header.
example;
lease 01012000 to 01012010 5000 year lease with 5% incremental increase
create schedules
01012000 to 01012001 value of 5000 * 5% = 5250
01012001 to 01012002 value of 5250 *5% = 5512.00 etc
I'm attempting this via a form/subform and queries attached to macros
I'm wondering how you would outline this attempt. Details later
Thanks
form that will enable a user to input header information that will create
detail records in the database.
Basically; user will input a lease term date range and yearly lease amount
.. This term (usually 10 years) will have a scheduled increase of 5%. I need
to be able to calculate the yearly scheduled increases as detail records to
the header.
example;
lease 01012000 to 01012010 5000 year lease with 5% incremental increase
create schedules
01012000 to 01012001 value of 5000 * 5% = 5250
01012001 to 01012002 value of 5250 *5% = 5512.00 etc
I'm attempting this via a form/subform and queries attached to macros
I'm wondering how you would outline this attempt. Details later
Thanks