Amortization table in Access?

[Guest]

Is there a way to create a working amortization table in an Access database?
I have an Excel spreadsheet that calculates payoff amounts for finance
accounts, but the statements for these accounts are process through Access.
If I could get the amortization table working in Access, it would save me a
great deal of flipping back and forth between screens, plus I could have the
payoffs calculated automatically.

 

[John Vinson]

Is there a way to create a working amortization table in an Access database?
I have an Excel spreadsheet that calculates payoff amounts for finance
accounts, but the statements for these accounts are process through Access.
If I could get the amortization table working in Access, it would save me a
great deal of flipping back and forth between screens, plus I could have the
payoffs calculated automatically.

You can't get an amortization *TABLE* but I'm sure you can get an
amortization *QUERY*. Tables contain only "real data"; if you're doing
calculations, use a Query.

I haven't actually created a query that does amortizations, so I'm not
certain what functions are available. You might need to reference the
Excel program library to get things like PresentValue, or recreate the
amortization functions in VBA.

John W. Vinson[MVP]

 

[James A. Fortune]

You can't get an amortization *TABLE* but I'm sure you can get an
amortization *QUERY*. Tables contain only "real data"; if you're doing
calculations, use a Query.

I haven't actually created a query that does amortizations, so I'm not
certain what functions are available. You might need to reference the
Excel program library to get things like PresentValue, or recreate the
amortization functions in VBA.

John W. Vinson[MVP]

Referencing the Excel Object Library, although that would work, is not
necessary for Present Value calculations. Check out the functions built
into Access such as PV and Pmt. Rolling your own functions for Present
Value calculations is fairly easy if you need to go slightly beyond the
functions provided by Access.

James A. Fortune