Create Master-Child links with multiple fields for multiple subreports

[Rani VSPL via AccessMonster.com]

Hi Group
Is it possible to create Master-Child links between report(Part Types) and subreports(Orders, Inventory)(two in number). Only a single field(Part No) is common between them, but I need to generate report based on two criteria i.e on Part No and Date Range(Start and End Date) which is not common to all the three.
Any Suggestions!!!!

 

[Allen Browne]

You cannot use the LinkMasterFields/LinkChildFields for a date range, so you
are looking for another way to filter that.

One alternative is to provide a form where the user enters the limiting
dates, and a command button to open the report. In the main report's query,
in the Criteria row under the date field, you will have something like this:
Between [Forms].[Form1].[StartDate] And [Forms].[Form1].[EndDate]
Do the same in the subreport's query. That's the simplest way to filter them
both to the same range.

To ensure Access interprets the dates correctly:
- Set the Format property of the unbound text boxes on the form to "Short
Date".

- In query design view, choose Parameters on the Query menu, and declare
them on 2 rows like this:
[Forms].[Form1].[StartDate] Date/Time
[Forms].[Form1].[EndDate] Date/Time