[AccessD] amortization

I used to regularly crib the formulas for stuff like this from my HP
calculator book! <VBG>  Actually VBA has a whole bunch of Financial
functions like NPV FV and PV that should work to give you what you want.

Charlotte Foust

-----Original Message-----
From: Bob Heygood [mailto:bheygood at abestsystems.com] 
Sent: Wednesday, October 08, 2003 1:47 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] amortization


I am looking for some code/examples of creating an amortization
table/report. I will have a beginning date, loan amount, a rate, and a
period of time. How can I make a report/table that reads:

Date   Payment Number   Payment Amount   Balance


TIA

Bob Heygood



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com