Linking 2 date range queries (1 Viewer)

[PeterOC]

Hi, Can anyone help me with this?

I have 2 tables:

table 1 (detailed jobchecks)

Region - CheckID - CheckDate

table 2 (summarised job totals by weekending date)

Region - TotalJobs - WeekEndingDate


I want to create a report that shows for a given week ending date the % checks to total jobs. I'm just not sure how to structure it. Do I need to create a new table with all the weeks' start and end dates and create 2 subqueries linking the two tables to this and then a third to link them together?

 

[PeterOC]

I'm going to go with the method I suggested to get around this problem which should solve the problem but I just wondered if there was a better way as building 5 queries seems a bit long winded.