Re: How do I fix this Running Sum query
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Mon, 27 Jun 2005 14:26:53 -0500
kevin0862 wrote:
>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
Please don't post the same question multiple times.
I believe I answered this in another newsgroup.
--
Marsh
MVP [MS Access]
.
- Prev by Date: Re: Converting Julian Dates to ##/##/## Format
- Next by Date: Sum Values in COlumn?
- Previous by thread: Get top customers and rest group as one Name?
- Next by thread: Sum Values in COlumn?
- Index(es):
Relevant Pages
|
