By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Statistical analysis functions in Access?

P: 1
Hello,

Are there any add-ins for access that would allow me to run a formula similar to the '=NORMDIST' function in excel?

If not, is my only choice to export the data into an excel spreadsheet, run my calculations, and export back results column using VB?

Thanks in advance.

Cheers,
John
Oct 5 '07 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
Hello,

Are there any add-ins for access that would allow me to run a formula similar to the '=NORMDIST' function in excel?

If not, is my only choice to export the data into an excel spreadsheet, run my calculations, and export back results column using VB?

Thanks in advance.

Cheers,
John
Actually, John, you're in luck :-)

You can call Excel functions from within Access using this command: Excel.WorksheetFunction.[FunctionName] ([Parameters]). This is shown using the Forecast function in the following link: http://www.thescripts.com/forum/thread701643.html

Regards,
Scott
Oct 6 '07 #2

Scott Price
Expert 100+
P: 1,384
I guess I should make that a little clearer: You can call these functions from within VBA code running in Access.

The function I posted a link to does just this, calling the function from a query.

Regards,
Scott
Oct 6 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
NB. You need to enable the link to the library first (It is not enabled by default).
From the Access window use Alt-F11 to open / switch to the VBA Window.
From there use Tools / References... to select the Excel library.
This may need to be repeated on other PCs if they also wish to use the database, but it may (now I think about it) be stored in the database instead.
Oct 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.