Access IRR function & reference library

[mike]

When I run the IRR function in Access, I get the error message
"Undefined function 'IRR' in expression." Presumably I need to load th
relevant reference library.

Can anyone tell me which library this is?

Also, does Access have the functionality to calculate IRR based o
non-periodic cashflows? (XIRR in Excel)

Thanks in advance,

Mik

 

[Brendan Reynolds]

The IIR function is defined in the VBA object library, and that object
library is always referenced in Access applications.

Perhaps you tried to use it in a query? That won't work. Documentation on
what VBA functions can or can not be used in queries, and why, is hard to
find, but my own tests indicate that no VBA functions that take an array as
an argument will work in a query. You could probably write a custom VBA
function that called the IIR function, and call the custom function from
your query.

I can't help with the second question, anyone else?