Dear All,
This is my first visit to your site and I am looking forward to tapping your great knowledge base!

I have designed an Access report that draws a graph (pivot chart) showing a trendline, regression equation and R-squared value. These are standard built-in capabilties of Access 2003. However, I wish to be able to write vba code that will put the R-squared value in a text box outside the pivot chart and, more importantly, to also give me the P-value (probability) and put it in another text box on the report page.

Is there anyone out there who can help me write the vba code to do this?

Very gratefully,


Frangi