Report based on Date with multiple different tables

[John B]

I am attempting to create a Status report that contains information from two
tables (lists in Sharepoint). One is status text that contains a week ending
date. The other is a task list with both a due date and complete date.

What I need to do is allow the user to pick the week ending date and
generate a report that includes
Status Text
Tasks complete in the last week
Tasks Planned in next 30 days

I can create queries that get the data.

I have created a form and used a function to open the report with a where
clause.
But the report only shows one table of information.
What I want to do is 'append' three reports so the users get one printed
report with the different types of informaiton.
Any assistance is greatly appreciated.

 

[bcap]

Three sub-reports?

 

[John B]

Yep,
I created a master report with three separate sub-reports and use a date
field on an unbounded form in each of the queries that drive each sub-report.
Thanks