Running totals for multiple fields - common subquery?

  • Thread starter Thread starter G Lykos
  • Start date Start date
G

G Lykos

Greetings! Am calculating running totals for multiple fields by week. Does
each running total require its own subquery, or can multiple running-total
fields be ganged in the same subquery? If able to be ganged, what is the
subquery syntax including output field designators?

Thanks,
George
 
You will need different subqueries to generate multiple columns in a query.

It might be easier to do this in a report. In the Sorting And Grouping
dialog, you can choose your date/time field on multiple rows, and create
groupings by week, by month, by quarter, by year. Alternatively, you can use
a Running Sum text box to accumulate totals. If you wish, use a couple of
Running Sum text boxes, one set to Over Group (so it shows the group total),
and the other to Over All (so it accumulates a grand total.)
 
Back
Top