G
Greg
I originally posted this some months ago and now trying to attack it again.
I'm relatively new to this, i'll explain as clearly as i can.
What i'm trying to achieve is on my form i want to calculate a current
payout figure based on the current date and start date of lease. I can do
this in an Excel Spreadsheet but, just don't how to reproduce on a form.
Currently i paste the Excel Spreadsheet into a report, however this is too
complicated for new users and the database is growing too quickly.
Each payment doesn't have it's own record.
My form is called : Cars
My fields are:-
FleetNo: (text field - primarykey)
StartDate:
EndDate:
NoOfPaymentsMade:
FinanceAmount:
InterestAmount:
InterestRate:
Payment:
Subtotal:
Total:
If i need more fields to achieve this please advise.
I have the following calculation which is correct based on 1 payment, but
need to repeat based how many payments have been made but using the new total
in each calculation.
[FinanceAmount ]*[InterestRate] = [InterestAmount]
$15002.00*0.0729 = $91.14
[FinanceAmount]+[InterestAmount] = [Subtotal]
$15002.00+$91.14=$15093.14
[subtotal]-[Payment] = [Total]
$15093.14-$359.08 = $14734.06
I hope this is clear enough guys, any suggestions?
GregE.
I'm relatively new to this, i'll explain as clearly as i can.
What i'm trying to achieve is on my form i want to calculate a current
payout figure based on the current date and start date of lease. I can do
this in an Excel Spreadsheet but, just don't how to reproduce on a form.
Currently i paste the Excel Spreadsheet into a report, however this is too
complicated for new users and the database is growing too quickly.
Each payment doesn't have it's own record.
My form is called : Cars
My fields are:-
FleetNo: (text field - primarykey)
StartDate:
EndDate:
NoOfPaymentsMade:
FinanceAmount:
InterestAmount:
InterestRate:
Payment:
Subtotal:
Total:
If i need more fields to achieve this please advise.
I have the following calculation which is correct based on 1 payment, but
need to repeat based how many payments have been made but using the new total
in each calculation.
[FinanceAmount ]*[InterestRate] = [InterestAmount]
$15002.00*0.0729 = $91.14
[FinanceAmount]+[InterestAmount] = [Subtotal]
$15002.00+$91.14=$15093.14
[subtotal]-[Payment] = [Total]
$15093.14-$359.08 = $14734.06
I hope this is clear enough guys, any suggestions?
GregE.