Running Totals in Access Query

[CalvT]

I have the following query set up:

SELECT Days.DMY, Sum(GVA12.IMPORTE) AS SumOfIMPORTE, GVA12.COD_VENDED


FROM Days LEFT JOIN GVA12 ON Days.DMY = GVA12.FECHA_EMIS
GROUP BY Days.DMY, GVA12.COD_VENDED;

And it gives the following result:



I want to add a running total in a fourth column, that will not omit the blank columns. So it would start 0,1000,3000,3000,3000,3000,4000 etc.

Thanks

[orange]

Try this link http://support.microsoft.com/kb/290136

[A S MANN]

A VBA code and a macro which run in a loop will solve this problem.
In row 1 Let Dim X As Integer
X = X + SumOfIMPORTE
By macro go to Start
X = SumOfIMPORTE
Go to Second Row
X = X + SumOfIMPORTE

Continue till end You can also show X value in a new field
You can thought more to reach to solution