Calculate cumulative on a report???

[buckwheat]

I have a table that that has three records I want to query and place on a report. 1 is the date, 2 is errors, 3 is volume.
Example
date errors vol
12/1 2 1000
12/2 1 900
12/3 2 1100

I want to list these numbers at the top of a report. (No problem.) But I also want to show to the right the cumulative numbers and frequency and then graph them at the bottom. There is a years worth of data and I will be printing weekly and monthly reports.
Example
date errors vol. freq.
12/1 2 1000 500
12/2 3 1900 633
12/3 5 3000 600

 

[Andrew Fergus]

Hi, to calculate the running totals (or cumulative totals) on a report, have a read of this article from Microsoft. Whilst the version they use is 2003, the same conecpts will apply to older versions of Access. I can't help with the graph sorry.

HTH, Andrew.

 

[buckwheat]

Thanks, I will toy with that and then go from there.

 

[P Sitaram]

See if this helps:

http://support.microsoft.com/?kbid=208633