Excel Functions within Access

[statto]

I'm trying (without luck) to use some excel functions within an access query (namely NORMSDIST and NORMSINV). Error is being returned 'undefined function'. I have switched on the MS Excel 11.0 Library.
Anybody any ideas?
Thanks

 

[TanisAgain]

Dunno if this helps?

http://support.microsoft.com/kb/198571/en-us

 

[statto]

Thanks - looks promising, will give it a try

 

[statto]

Works - thanks again

 

[mcgrcoAgain]

Does anyone have a vba function that replicates excels NormSDist. using the inbuilt excel function is slow and cumbersome when trying to update 1000s or records. i manged to find a vba equvilient for NormSInv but not NormSDist. Any help is appreciated