I realize this is a development question but I really need some ideas.

I have a table with tasks that has a job number, finish date, scheduled hours and a duration of work(days). This is a many table where one job number could have 1 to what ever many tasks.

My goal is to have a report with the job numbers listed as rows and the sum of hours for each of the next twelve months listed as the columns.

I am using SPT to access the data.