Need to build a report with a filter by date range, that when the report opens the date range is used to filter subreports.

I am trying to build a report that uses a date range to filter the report to specific records.  The report its self has 6 subreports used to consolidate data and total the number of records.  The problem I have is that the date range put in the main form needs to be passed along to the subforms.  

The data I am collecting is for a medical database on a construction site.  The catagories can be:  Occupational Injury, Occupations Illness, Non-Occupational.  There is also a series of selectors for First Aid Case (FAC) or Medical Treatment Case (MTC).  The report I am trying to build will look like this:

 - Occupational Injury - FAC = 10
 - Occupational Injury - MTC = 1

 - Occupational Illness - FAC = 1
 - Occupational Illeness - MTC = 0

 - Non Occupatonal FAC = 15
 - Non Occupatioanl MTC = 4

My original attempt was to create a master report with 6 subreports (each subreport has its own Query).  Each subreport has a record counter in the footer that give me the desired result of counting the records.  To beakout the data, I used grouping and sorting in the subreports  to breakout the exact data needed.  Everything works fine if I want to totals for all data in the database.  The problem is I need to sort all the data by a date rage, and I do not want to enter the date rage 6 times (one for each subreport).  Any suggestions?
Start Free Trial