J
juliejg1
I am creating a database to track savings generated and am stuck on a date
issue. There are three parts that will determine what is done with the date.
A combo box with a list of starting dates (mm/yy)
A textbox indicating how many months the savings will last
A textbox indicating what the total savings is.
People can enter as many months as they wish but we will only track up to 12
months.
If they have a starting date of 06/07 with total savings of $14,000 and
number of months is 14 I need to be able to divide the total savings by
number of months and have $1,000 put into 12 date fields (june 07 - may 08).
I am not sure how I can have the calculated amount entered into the correct
date fields in my table.
issue. There are three parts that will determine what is done with the date.
A combo box with a list of starting dates (mm/yy)
A textbox indicating how many months the savings will last
A textbox indicating what the total savings is.
People can enter as many months as they wish but we will only track up to 12
months.
If they have a starting date of 06/07 with total savings of $14,000 and
number of months is 14 I need to be able to divide the total savings by
number of months and have $1,000 put into 12 date fields (june 07 - may 08).
I am not sure how I can have the calculated amount entered into the correct
date fields in my table.