Cummulative Average

[Ron]

I have a table that has task start and end dates. I have a query built to
group by the end date by week ending (group everything with and end date from
Sat to Fri) and average the calculated "day open" (end date - start date).

For example, for the fisrt week of the year, the tasks closed that week had
been open on average 53 days, the second week of the year it was 49 days.
However, each average only looks at the week in question. I'd really like to
have each week look at the cummulative average YTD (2nd week looks at both
the 1st and 2nd, not just the 2nd).

I've been exporting the data to Excel, but many people access teh database
already to do research and I'd like to have this chart in the database so
people don't have to go to another location to see the chart. Not to mention
that I would have to manipulate the data in Excell each week, I could just
let Access do the work for me.

 

[S.Clark]

I would solve by writing data each week to another table, then query that
table to get the Cumm Avg. So, each week, write a new record to the table
using an Append Query.

When you say chart, I think you mean a pie graph, bar chart, or some other
graphical device for display. If so, then you can add it to a form or report
using the Graph control.