add fvschedule function to msaccess

  • Thread starter Thread starter Guest
  • Start date Start date
There is such a thing. The FVSchedule function is used to calculate the
future value of an investment with a variable or adjustable compound rate.
It's in the Analysis Toolpak Add-in that is intended to be used within
Excel, not Access. Your best bet may be exporting the data for both the
principal and the compound interest rates into a spreadsheet, then using
automation to run the calculation. The result can be linked to or imported
into Access. Ask in the Excel NG how to install and use the Analysis Toolpak
if you need help.

Abe
 
Thanks honest abe...

Honest Abe said:
There is such a thing. The FVSchedule function is used to calculate the
future value of an investment with a variable or adjustable compound rate.
It's in the Analysis Toolpak Add-in that is intended to be used within
Excel, not Access. Your best bet may be exporting the data for both the
principal and the compound interest rates into a spreadsheet, then using
automation to run the calculation. The result can be linked to or imported
into Access. Ask in the Excel NG how to install and use the Analysis Toolpak
if you need help.

Abe
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

FVSCHEDULE 3
Daily compound interest 2
FVSCHEDULE should allow cell reference for interest rate schedule 1
how to remove html tags from a field in MSACCESS. 1
geometric mean of a series of negative asset returns 8
How to write loop syntax in MSaccess 1
precision in access versus excel 1
Access 2003 functions 3

Back
Top