IRR Function in Access?

[Guest]

Hi,

How can I use IRR function in MS Access? I've tried but all I get is
"#name?". Please help.

BR
-G.

 

[Lynn Trapp]

IRR is an Excel function, not an Access function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Lynn Trapp]

I also meant to add that you can add a Reference to the MS Access 11.0
Library and use the function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Roger Carlson]

As Lynn said, IRR is an Excel function rather than Access. You will
probably have to calculate it yourself in a custom function. Here's an
article that shows how to calculate the IRR:
http://invest-faq.com/articles/analy-int-rate-return.html


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Arvin Meyer]

You can use it from Access, but you'll need to set a reference to Excel,
then write an Access function like (air code):

Function XL_IRR(Arg1, Optional Arg2) as double
Dim objXL As New Excel.Application
' Arg2 is optional below. (Leave out the comma too)
XL_IRR= objXL.WorksheetFunction.IRR(Arg1,Arg2)
Set objXL = Nothing
End Sub

And pass it the values and Optionally the guess.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I would like to ask still on this problem. I am not too familiar with the
visual basic and don't seem to get this code working. I did set the reference
to excel. Then I did a new module and copied the code there. On Access query
I chose this function and gave a field name where the function would get the
values from. And it doens't work... I also tried to change the code a bit and
changed the end to 'end function'. I received run time error 1004, couldn't
use the class worksheet function IRR.

Obviously I am doing something wrong. But what??

Help is appreciated,
Jari



"Arvin Meyer" kirjoitti: