var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Does anyone know of an equivalent function or code block in Access VBA for the NormSDist function from Excel?
Try this link, and see if that is what you are looking for.
Access Design Tips
That was it. Thanks!
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.
"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
XTreme VB Talk
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors