Cumulative calculation

  • Thread starter Thread starter DanielS via AccessMonster.com
  • Start date Start date
D

DanielS via AccessMonster.com

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

Not sure how to attack this one?!!!

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
 
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
 
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 said:
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
Click to expand...
[quoted text clipped - 30 lines]
Click to expand...
 
Could you run your query and export the results to Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

DanielS via AccessMonster.com said:
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 said:
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
Click to expand...
[quoted text clipped - 30 lines]
Daniel
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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
Click to expand...
[quoted text clipped - 22 lines]
Click to expand...
 
Back
Top