Calculation of NPV in Spreadsheet and connected to Access form for

[Guest]

I have an access form that asks the user to input all the pertinent data
(periods, tax rates, discount rates, depreciation, economic life etc) into
the access database. Can I use an excel spreadsheet to calculate NPV and
then have the Access form pul the result from the spreadsheet? Thanks in
advance for your help!

Linda

 

[Guest]

Hi, Linda.

Better still, since Microsoft decided to leave an NPV function out of
Access, why not write your own?

See
http://support.microsoft.com/default.aspx?scid=kb;EN-US;268159

or Google "NPV function Access"

Then you don't need to store anything; just calculate it on-the-fly as you
need it.

Hope that helps.
Sprinks

 

[Joshua A. Booker]

Linda,

Any calculation that you can do in Excel can be done in an Access form.
Simply add another text box to the form, then type "=" and the calculation
in the recordsource property.

HTH,
Josh