Regression Analysis in Acess via VBA?

[VBUser77]

Is there a way I could perform trend/regression analysis on data stored in an access table through VBA coding?

I could easily perform regression analysis through Excel but I am trying to build a forecasting tool in access and would like to use access to do the regression analysis.

Any ideas/thoughts? Thanks a lot for your help in advance.

Jay

 

[MichaelRed]

I looked (Briefly) and found no significant info here (Tek-Tips / My Fora) dealing w/ regression analysis.

I have some code left over from ye days of olde (FORTRAN) which does regression analysis and have "toyed" with translating it into a viable VB/Ms A application but have never really finished it.

In the toying process, I also looked around on the web -at the time mostly to see if there was any interest or already developed code. Unfortunatly, the results were not particularly encouraging (at least for me). There are numerouus 'high end' packages available (at the usual 'high end' price range). These generally tend to be adjusnct to the standard stats packages and are occassionally advertised as an intergal part thereof. My original use was for engineering, and so it does not really fit into these niches.





MichaelRed