Correlation calc in query

[mike02]

Hello,



I have looked into the built functions in access and cannot find the correlation function.

Is it possible to calculate correlations in this set up:

I have a table called REturns:

MonthDate....Return...ID

there are hundreds of sets of returns:
for each set it has a common ID, how i search, and show who the returns are for. Is there a way to do a correlation calculation between on set and another set(the one i select in a form)

Thanks

[Dal Jeanis]

I found three pages that seemed useful on calculating correlations in Access. Does any of these help?

http://www.mrexcel.com/forum/microso...a-columns.html

http://www.experts-exchange.com/Micr...MS-Access.html

http://www.tek-tips.com/viewthread.cfm?qid=262180

[mike02]

thanks for the links, I will use them for help!