Statistical analysis functions in Access?

[bambam28]

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

[Scott Price]

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

[Scott Price]

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

[NeoPa]

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.