Running Sum in a query

[Jeanette]

I have a table with a commitdate and a closingDate. I want a running sum of the City$ field. I only want a running sum of the City$ of each closing date that is less than the commitdate. Can this be done in a query? Thanks in advance.

 

[Cosmos75]

Sample database: Query - Perform Running (Sum / Total / Average / Count) Calculations

See Running Sum / Total / Count / Average in a query using a correlated subquery article.

Hope this helps!

 

[Pat Hartman]

It is FAR better to calculate your running sums in a report.

 

[Cosmos75]

It is FAR better to calculate your running sums in a report.

More on that here. Thought this might save Pat from having to explain again.

 

[Pat Hartman]

That wasn't even the long explaination. There was one where I estimated the number of I/O's required.