Amortization table in Access?

  • Thread starter Nicholas Scarpinato
  • Start date
N

Nicholas Scarpinato

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.
 
J

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]
 
J

James A. Fortune

John said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top