Anyone know how I can perform the Excel NORMSDIST function in Access?
Thanks
Anyone know how I can perform the Excel NORMSDIST function in Access?
Thanks
Did you solve this and do you care to share with others that read this forum?
I actually copied over a Module that included the Excel NORMSDIST function from an Access database that was forwarded to me and it wasn't working. I googled for an answer how to get the NORMSDIST function from Excel into Access. One of the solutions was to create a Module, which I did by copying over the Module but it wasn't working. After further reading I noticed I had to "activate" Excel functions in Access. To do this, I had to be in Visual Basic, click on Tools, then References and click the box next to Microsoft Excel and then hit ok. It then worked for me. Below is the Module I copied over and it worked for my puproses, but unfortunately I wouldn't be able to break it down and explain how it all works.
Public Function N(X As Double) As Double
N = Excel.WorksheetFunction.NORMSDIST(X)
End Function
I hope this helps you out.
Thanks. That's better that a single post thread with just a question, marked as Solved.