NORMSDIST and NORMSINV functions 1

[1661]

I know these functions work in excel and I was trying to use them in an Access query but they seem to be giving an error. How should I go about using the NORMSDIST and NORMSINV function in Access?

Please reply.

Thanks!

 

[HitechUser]

1661,

These function do not exist in Access. Sooooooooo

This may work for you.

Try adding the "Microsoft Excel Object Library" reference in the references category.

Then use a function like this.

Public Function norm(z As Double) As Single 
    Dim a As Double 
    Dim objExcel As Excel.Application 
    Set objExcel = New Excel.Application 
    norm = objExcel.WorksheetFunction.NORMSDIST(z) 
    Set objExcel = Nothing 
End Function

Just create another function for NORMSINV.

Hey I hope this helps..

 

[1661]

Thank you very much...I just tried it and I think it works!!

Thanks again...really appreciate it