How do you create a Running Total in an Access Quiery

[mcconnellrc]

Given a tabel with the following data<br>
Month Cost<br>
Jan 10<br>
Feb 15<br>
Mar 12<br>
<br>
How do you set up a querry to calculate a running sum<br>
Month Cost RunningCost<br>
Jan 10 10<br>
Feb 15 25<br>
Mar 12 37<br>

 

[Hallsys]

Easy to do in a report, by creating a recordset and calculating the running sum, or using a maketable query and doing an update. I don't think this can be done in a one off query to produce this result.

 

[eic]

In a query, you can accomplish a running sum by using Dsum. The criteria in this case would be <br>
RunVol: (DSum("[Cost]","Tblename","[datefld] &lt;= " & [datefld])).<br>