Cumulated value until particular date

[voxjoy]

Hi,



I wonder if anyone can help me. I am trying do define a query which would calculate cumulated value of the column single_value based on the date (cumulate values until the date in particular row). Here's the source table:


And here is how I would like the query to display results (I typed it manually just as an example):


Thanks in advance for any ideas.

[orange]

Research running sum or running totals query

see
http://support.microsoft.com/kb/290136
http://www.techrepublic.com/article/...-query/6140569

[voxjoy]

Thanks a lot, it's working fine.

[orange]

Glad you have it working. I'll mark it solved.