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
 
Back
Top