How do I fix this Running Sum query

K

kevin0862

Joined
Jun 24, 2005
Messages
3
Reaction score
0
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
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset my running sum with new/different date range(s) 1
DATABASE REPORT/CROSSTAB QUERY HELP 2
How to look up a value in a list and sum multiple corresponding va 2
Counting with multiple criteria in separate Columns 6
Complicated Query - Ranges, Accruals and F/X Rates 1
Access query sum buy column 2
Fiscal year 2
Query running sum - help again 2

Back
Top