Running sum of percentage field

[herbertioz]

I am trying to make a query that give me an output of an aggregate percentage column, or running sum of percentage. Please see my example:

Month Sales in % Running sum percentage
Jan 5.03 % 5.03 %
Feb 2.17 % 7.20 %
Mars 1.28 % 8.48 %


I have the column Month and Sales in %, What do I have to do to get an output like the example over?

I hope someone can help me

 

[plog]

That's just a plain running sum query. Search the forum for that term. Answered plenty of times.

 

[herbertioz]

I found out the solution and the solution was the following:

SELECT Month, Sales,
DSum("Sales","table1","ID <=" & [ID]) AS RunningSum
FROM table1;

Thanks Access Programmers