Problem creating running totals

[JosephRoy]

Hello,

I have a query in which I would like to create a couple of running total fields. This query is based on another query. The results look like this:

Week# Amount Games
1 600 3
2 650 3
3 590 3
4 620 3

What I would like is the following:

Week# Amount Games SumAmt SumGms
1 600 3 600 3
2 650 3 1250 6
3 590 3 1840 9
4 620 3 2460 12

Any help would be greatly appreciated.

Thanks.

 

[lupins46]

Assuming you are using the query grid then add Week, Amount, Games. I have called your first query Query1.
Then add :

SumAmtsum("[Amount]", "Query1", "Query1.Week <= " & week)
In the next column:
SumGamessum("[Games]", "Query1", "Query1.Week <= " & week)