How do I fix this Running Sum query

K

kevin0862

I know that this has been answered over a thousand times, but I've bee
working on this project and for the past 5 days I am unable t
calculate a running daily sum. Can someone assist me please?

Confused :confused:

_Associate__Name___|_____Date_|___Daily_Production__|___RunTot_
Jane Doe | 1/3/05 | 105 |
105
Jane Doe | 1/4/05 | 140 |
245
Jane Doe | 1/5/05 | 100 |
345


My expression has been written as:

RunTot: (SELECT Sum([Daily Production]) From [Associate Dail
Production] A WHERE A.[Date Completed]<=[Associate Dail
Production].[Date Completed])

My results are as follows:

_RunTot_
1470
3565
548
 
M

Marshall Barton

kevin0862 said:
I know that this has been answered over a thousand times, but I've been
working on this project and for the past 5 days I am unable to
calculate a running daily sum. Can someone assist me please?

Confused :confused:

_Associate__Name___|_____Date_|___Daily_Production__|___RunTot_
Jane Doe | 1/3/05 | 105 |
105
Jane Doe | 1/4/05 | 140 |
245
Jane Doe | 1/5/05 | 100 |
345


My expression has been written as:

RunTot: (SELECT Sum([Daily Production]) From [Associate Daily
Production] A WHERE A.[Date Completed]<=[Associate Daily
Production].[Date Completed])

My results are as follows:

_RunTot_
1470
3565
5480
Click to expand...


Please don't post the same question multiple times.

I believe I answered this in another newsgroup.
 
Top