Period totals and running totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, can you please tell me how to achieve the following? I need to produce
a report showing two columns, for example:

Cases opened week beginning [date] Total cases opened
Cases closed week beginning [date] Total cases closed

I don't need any record details, just the totals.

I can't work out how to achieve this because in my query acting as record
source I am filtering for data that falls within the specified period and
counting those records, but this obviously excludes the data needed to
populate my 'running totals' fields. Can anyone suggest a way of displaying
both running totals and current week totals in the same report (or form, if a
form is the best means of achieving it)?

Many thanks in advance

Tim Long
 
hard to say from your description....

possibly the groupby function in the report can be used by week.

but it looks like you are trying to calculate totals of two different
periods simultaneously....you might first consider satisfying this summing
via query/sql - and then consider the Report only as a presentation vehicle
rather than relying on the Report to do the summing....

but not sure as it kind of depends on where the raw data is and how it is
layed out that goes into these sums....
 
Back
Top