Running Total

[Guest]

I found the answer to my question in the Search Results on how do you create
a query showing a running totals. My question is how do you accomplish this
without writing the statment below? I want to remain in the query grid.

Answer from Search Results:
Use a calulated field that consists of a subquery.
RunAmt: (SELECT Sum(Amt) FROM table As X WHERE X.date <=
table.date AND X.employee = table.employee)

Sample Table:
Row 1 - Smith, 1/1/05, $500, $500
Row 2 - Smith, 1/8/05, $750, $1,250
Row 3 - Smith, 1/9/05, $100, $1,350

 

[John Spencer]

You can only do this in the query grid by entering the statement in a
(field) column as shown.

On a report, you can use a control to sum over a group to have a running
total. That is a different question.