Hourly Sum... Include previous Sum?

[tqeonline]

Hey guys... I have an idea about a chart I want to have... but can't get my head around it.

Say you have been given this data:
Time Test Scripts
10/1 10pm 1
10/1 11pm 2
10/2 12am 1
10/2 1am 3
10/2 2am 2
10/2 3am 4
10/2 4am 3
10/2 5am 1

How would you get it to sum all the test scripts from that hour to a previous point in time. So say you are given a start date of 10/1 and an end date of 10/2 and you want to know the sum of tests scripts that were completed including that hour... so the results would be:

Time Test Scripts
10/1 10pm 1
10/1 11pm 3
10/2 12am 4
10/2 1am 7
10/2 2am 9
10/2 3am 13
10/2 4am 16
10/2 5am 17

it's kind of like it is just adding the sum of the row before it..

Any ideas?



- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[markros]

Try googling on 'Running total'.

Here is a good thread on this topic in another forum:

Lightning Fast Hybrid RUNNING TOTAL - Can you slow it down?

PluralSight Learning Library