charlie442
Registered User.
- Local time
- Today, 06:33
- Joined
- Jan 14, 2011
- Messages
- 53
Hi
I am really stuck on how to do this. I am no vba expert but I took this project on thinking how hard can it be. Unfortunately it has totally flummoxed me
.
Essentially I have a table of historical interest rates (fields are : Interest_Rate, Rate_Start_Date and Rate_End_Date).
Then I have a query which calculates, for each payment we recieve, the payment due date, the actual payment date, the difference in months.
But now that I have this information (which I think is all I require) I am struggling to make the link. Basically what I need my database to calculate is, for all late payments what is the interest charge given that the interest rate charged may have changed since the due date of payment (the interest is calculated monthly). In other words it could be the case that for the first 3 monts one rate is charged, for the next 6 months a different rate is charged and so on, each time charging interest on previous periods interest as well as the capital amount.
Can anyone point me in the direction of an article or an example database where this is explained/done. I dont really want to waste you experts time by explaining everything and am happy to work through an example. This is a better way to learn how to do it again should I need to.
Any ideas most welcome.
Thanks
I am really stuck on how to do this. I am no vba expert but I took this project on thinking how hard can it be. Unfortunately it has totally flummoxed me

Essentially I have a table of historical interest rates (fields are : Interest_Rate, Rate_Start_Date and Rate_End_Date).
Then I have a query which calculates, for each payment we recieve, the payment due date, the actual payment date, the difference in months.
But now that I have this information (which I think is all I require) I am struggling to make the link. Basically what I need my database to calculate is, for all late payments what is the interest charge given that the interest rate charged may have changed since the due date of payment (the interest is calculated monthly). In other words it could be the case that for the first 3 monts one rate is charged, for the next 6 months a different rate is charged and so on, each time charging interest on previous periods interest as well as the capital amount.
Can anyone point me in the direction of an article or an example database where this is explained/done. I dont really want to waste you experts time by explaining everything and am happy to work through an example. This is a better way to learn how to do it again should I need to.
Any ideas most welcome.
Thanks