Running totals for multiple fields - common subquery?

[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

 

[Allen Browne]

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.)