Automatically generate calculated fileds on a form

[Guest]

I have a financial database tracking repayments on various loans, i.e
mortgages etc. I have created some calculated fields on my form to show what
the settlement figure would be for a loan on a month by month basis (loan
balance minus monthly repayment etc). The repayment period could be anything
from 12 months to 120 months. Can Access automatically generate the correct
number of settlement figures for each month depending on the period - ie. if
the repayment period is over 12 months I would like to have 12 calculated
fields for the settlement figures for each month, if the repayment period was
60 months then I would like to have 60 calculated fields for the settlement
figures etc. Is this possible with some coding, and if so does anyone have
any examples of the code rerquired and where the code would have to be placed?

Any help would be very much appreciated.

Taffy B

 

[Jeff Boyce]

Taffy

If you can describe the formula/expression, you can (probably) create that
expression as the source for a textbox. You'll need to do the work to come
up with the formula.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/