Graph Question

[PeterOC]

Hi,

I've got a database table containing
JobNumber - JobRaisedDate - JobCompleted Date

What I'd like to do is have a graph showing:

* Total Jobs Raised
* Total Jobs Completed

...for every week.

Sounds easy but here's the thing: when I group on raised date I get all the jobs that were raised in the week + any jobs that we're raised and completed in that week. I'm missing jobs that were raised prior to that week.

I feel like I'm missing something simple with this. Any suggestions?

Cheers,

Pete

 

[Endre]

Here's how I would do this - see attached mdb.

There are other ways too.