Cumulative montly values from SQL?

[connel81]

Hi,

I'm trying to create a chart object, and it gets its details from a table that contains two fields:

-Job Date
-Hours

I want the chart to be grouped by the month, but i want the sum of the hours to be cumulatively displayed as the months progress, rather than the sum of the hours being displayed for just THAT month!

In other words, the data that should be returned:

Month sum of hours
Jan 7
Feb 15 (7+8)
Mar 20 (7+8+5)

I'm trying to find the right SQL statement to apply as the data source for the chart. Please help Meeeeeeee!!!!!

thanks in advance