Create Master-Child links with multiple fields for multiple subreports

  • Thread starter Thread starter Rani VSPL via AccessMonster.com
  • Start date Start date
R

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!!!!
 
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
 
Back
Top