Combine 3 reports but use DATE as a where criteria

[gangel]

Wow i couldnt even think of a subject title for this!!

So my issue is this:

I have 3 reports:
Batches Entered
Batches Checked
Payments Received

Each of these is based on a separate query which shows all of the "occurances" next to a staff name.
Each report then is grouped by staff name and the sum of the occurances is written next to their name.
In short:
John [5]
Sally [10]


Bob [ 2]

So i know how many of the above actions they are doing.

As the original report has the date field in it and is grouped in the report, i can then open the report showing where BatchDate = between 1/1/15 and 1/12/15


It is now that I am stuck..

I dont want to open all 3 reports and look at what has occured in those dates. I want all 3 reports to be sub reports... but how do i ge tthe WHERE to work in this case??

Hope i have been clear :S

Gangel

[pbaldy]

I'm not sure I understand. If they work as stand alone reports they should still work as subreports. If the criteria pointed to a form, you wouldn't get repeated prompts, if that's the issue.

[June7]

If the subreports need more filtering than can be established by the Master/Child Links properties, only method I know is to have dynamic parameterized query as the RecordSource of the subreport.