Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Normsinv

Status
Not open for further replies.
debrarosie

debrarosie

IS-IT--Management
Joined
Nov 27, 2001
Messages
4
Location
US
Has anyone used the Normsinv function in Access 2000? How did you accomplish this? Thanks!
 
Sort by date Sort by votes
Normsinv does not exist in my help system. Even WORSE, attempting to call / execute does not reveal any arg prompt, and returns NOt found.

STRONGLY suspect this is NOT an access function.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
I was actually able to accomplish this by remotely programming in excel.

In access I open up an excel worksheet object. I place the equation "=Normsinv(a1)" in cell b1. Then I open a recordset in access. I take the value K place it in cell a1. Then in access I set the variable Normsinv_k to cell b1. Then I update the recordset. Then I move to the next record.

It was slower than I would prefer (about 60,000 rows/hour) but it worked.
 
Upvote 0 Downvote
It would help some, to reference the excel library. If you do that, you can use the function from the application (.MDB) where the reference is. Saves having the Excel App actually running (and taming up memory).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top