Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: NormSDist function in Access

    Does anyone know of an equivalent function or code block in Access VBA for the NormSDist function from Excel?

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Try this link, and see if that is what you are looking for.

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    That was it. Thanks!

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You could also roll your own normal (gaussian) distribution generator, based on rnd. That way, you wouldn't need to automate Excel. (it should be substantially faster if you keep things inside VBA)

    Ref post #9 here.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •