I need to calculate at each record a cumulative base on current record +
previous record.

Not sure how to attack this one?!!!

Daniel

-- 
Message posted via http://www.accessmonster.com

Define "previous" ... records in Access tables have no particular order 
unless you impose it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"DanielS via AccessMonster.com" <u21482@uwe> wrote in message 
news:7a30676a99e29@uwe...
>I need to calculate at each record a cumulative base on current record +
> previous record.
>
> Not sure how to attack this one?!!!
>
> Daniel
>
> -- 
> Message posted via http://www.accessmonster.com
> 

The table refers to the billable time of engineers, instead of dates I have a
2 week payperiod.

EmplNum          PPID            Direct          Fiscal
5                      1                  5                 2007
5                      2                  3                 2007
so on to 26 for current fiscal.
I need to sum/cumulative the Direct. i.e.
EmplNum          PPID            CumDirect          Fiscal
5                      1                  5                 2007
5                      2                  8                 2007         
I have located a document that utilize dsum, but it is always giving me the
total for the table and not the proper result. In the example they are
utilizing a date.

Hope this helps you help me,
Daniel

Jeff Boyce wrote:
>Define "previous" ... records in Access tables have no particular order 
>unless you impose it.
>
>Regards
>
>Jeff Boyce
>Microsoft Office/Access MVP
>
>>I need to calculate at each record a cumulative base on current record +
>> previous record.
>>
>> Not sure how to attack this one?!!!
>>
>> Daniel

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200710/1

Consider then, instead of trying to get a query to do this, using the query 
to return the "raw" values and using a report based on that query to produce 
"running sums".  You can add a control to your report and set the running 
sum/total property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"DanielS via AccessMonster.com" <u21482@uwe> wrote in message 
news:7a37468769ae4@uwe...
> The table refers to the billable time of engineers, instead of dates I 
> have a
> 2 week payperiod.
>
> EmplNum          PPID            Direct          Fiscal
> 5                      1                  5                 2007
> 5                      2                  3                 2007
> so on to 26 for current fiscal.
> I need to sum/cumulative the Direct. i.e.
> EmplNum          PPID            CumDirect          Fiscal
> 5                      1                  5                 2007
> 5                      2                  8                 2007
> I have located a document that utilize dsum, but it is always giving me 
> the
> total for the table and not the proper result. In the example they are
> utilizing a date.
>
> Hope this helps you help me,
> Daniel
>
> Jeff Boyce wrote:
>>Define "previous" ... records in Access tables have no particular order
>>unless you impose it.
>>
>>Regards
>>
>>Jeff Boyce
>>Microsoft Office/Access MVP
>>
>>>I need to calculate at each record a cumulative base on current record +
>>> previous record.
>>>
>>> Not sure how to attack this one?!!!
>>>
>>> Daniel
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200710/1
> 

I did the report that you refer to. But the need is to chart in access the
running sum %. Has the pay period accumulates I calculate a running total of
direct over a total of total work against a goal for my chart.
In Excel it was easy but data entry and quantity of data was getting too much.

This is why I need the running totals in a query.

Jeff Boyce wrote:
>Consider then, instead of trying to get a query to do this, using the query 
>to return the "raw" values and using a report based on that query to produce 
>"running sums".  You can add a control to your report and set the running 
>sum/total property.
>
>Regards
>
>Jeff Boyce
>Microsoft Office/Access MVP
>
>> The table refers to the billable time of engineers, instead of dates I 
>> have a
>[quoted text clipped - 30 lines]
>>>>
>>>> Daniel

-- 
Message posted via http://www.accessmonster.com

Could you run your query and export the results to Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"DanielS via AccessMonster.com" <u21482@uwe> wrote in message 
news:7a4fe11105b39@uwe...
>I did the report that you refer to. But the need is to chart in access the
> running sum %. Has the pay period accumulates I calculate a running total 
> of
> direct over a total of total work against a goal for my chart.
> In Excel it was easy but data entry and quantity of data was getting too 
> much.
>
> This is why I need the running totals in a query.
>
> Jeff Boyce wrote:
>>Consider then, instead of trying to get a query to do this, using the 
>>query
>>to return the "raw" values and using a report based on that query to 
>>produce
>>"running sums".  You can add a control to your report and set the running
>>sum/total property.
>>
>>Regards
>>
>>Jeff Boyce
>>Microsoft Office/Access MVP
>>
>>> The table refers to the billable time of engineers, instead of dates I
>>> have a
>>[quoted text clipped - 30 lines]
>>>>>
>>>>> Daniel
>
> -- 
> Message posted via http://www.accessmonster.com
> 

Yes, technically.
But the intent is to have Access deal with data entry and output without the
inconvenience of accessing multiple applications.
I can easily create a spreadsheet that puls the data and then crunch it. 
But we want to be able to execute from access and then email the report to
the employee/mgr.

Jeff Boyce wrote:
>Could you run your query and export the results to Excel?
>
>Regards
>
>Jeff Boyce
>Microsoft Office/Access MVP
>
>>I did the report that you refer to. But the need is to chart in access the
>> running sum %. Has the pay period accumulates I calculate a running total 
>[quoted text clipped - 22 lines]
>>>>>>
>>>>>> Daniel

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200710/1