Averages

[DH]

Any suggestions please for the following problem I have.
I currently average the No of Days taken per month after remove certain people(not literally).

Example

Avg Month
14.00 April
27.61 May
34.00 June
39.25 July

I would like to create another column to show accumulative average totals e.g. April to April 14.00
April to May 24.65
April to June 32.79
April to July 38.95

If someone could point me in the right direction(and not the exit door)please

David

[This message has been edited by DH (edited 01-23-2001).]

 

[Richie]

Use a running sum.

 

[Pat Hartman]

It is extremely inefficient to do a running sum in a query since you need to use DSum() and you also need have a unique, ascending key to make it work. Do the running sum in a report.

 

[DH]

Thanks Pat & Richie,

I've tried the running sum in the report previousily and this is what I arrive at;

The totals add up until the end of the year and does not average.

April 14.00 14.00
May 27.61 38.33
June 34.00 72.33
July 39.25 111.58

It doesn't show

1st column Individual month
2nd column Accumulation of months

April 14.00 14.00... this is April to April
May 27.61 24.65... this is April to May
June 34.00 32.79... this is April to June
July 39.25 38.95...this is April to July

Is it just me not understanding the running sum or do I need to do something else within the query to calculate by more than one month at a time?

Thankyou

David

[This message has been edited by DH (edited 01-24-2001).]

 

[Happy YN]

I know I am over a year since you posted this but i think i have solved it for you!
See my post in query forum entitled running averages which query