Running Total Query

[stretch66]

Hi,

Am trying to create a query for a chart where I can total the employees over time but am having real trouble creating a running total from the "Total" field within a query but cannot seem to get it at all.

Total StartDate LeftDate RunningTotal
1 26/03/1957
1 21/03/1971
1 27/02/1986
1 15/02/1988
2 07/03/1988
0 07/03/1988 31/05/2007

Here is my current SQL query:

SELECT Sum([CountOfStartDate]-[CountOfLeftDate]) AS Total, Atest1.StartDate, Atest1.LeftDate, Sum([CountOfStartDate]-[CountOfLeftDate]) AS RunningTotal
FROM Atest1
GROUP BY Atest1.StartDate, Atest1.LeftDate;


Can anyone help please?

 

[neileg]

Not easy to do in a query, but it has been covered before. Try searching this forum for running total.

 

[Rabbie]

There is also information from Microsoft. Try Googling "Running Total ms Access"

 

[MStCyr]

Hi,

Am trying to create a query for a chart where I can total the employees over time but am having real trouble creating a running total from the "Total" field within a query but cannot seem to get it at all.

Total StartDate LeftDate RunningTotal
1 26/03/1957
1 21/03/1971
1 27/02/1986
1 15/02/1988
2 07/03/1988
0 07/03/1988 31/05/2007

Here is my current SQL query:

SELECT Sum([CountOfStartDate]-[CountOfLeftDate]) AS Total, Atest1.StartDate, Atest1.LeftDate, Sum([CountOfStartDate]-[CountOfLeftDate]) AS RunningTotal
FROM Atest1
GROUP BY Atest1.StartDate, Atest1.LeftDate;


Can anyone help please?

Hello

Please find attached a running total query. Hope this helps.

Maurice

 

[stretch66]

Hi,

Thanks for the link. Had seen examples before but couldn't get my head round how to rethink how I developed my query.

Thanks

 

[burrelly]

I have tried to use the following with no luck:

http://support.microsoft.com/kb/290136/en-us