How do you create an SPC chart with MS Access?

[jawalter]

I currently have a database where I have created a chart in a form based on a table. The chart displays the date on the x-axis and my product thickness on the y-axis. The chart currently averages all data that is taken on the same date and displays it as one data point. I was wondering if there was a way for me to use a query to calculate +/- standard deviation values to insert SPC upper and lower limits in the chart.

 

[brocky]

Hi,<br>
I,m about to run through a similar exercise. I work for a company making chemicals in batch-wise production. I've coded an application in Delphi, which I can e-mail the code for if you like. Change of company structure means that Delphi is now frowned upon and Access is the new king, so its start again.<br>
I'm just starting out in Access, so this might not be right, but it appears that the best way to do this might be to use an Excel chart as an unbound OLE object and supply the data through VBA code. This sound right? Give me a few days to get some access code for stddev function. I'll get bach to you.<br>
<br>
Chris<br>
Melbourne