Access sub-report Sorting

[Guest]

Access sub-report Sorting

Help!!! I am new to MS Access 2000 and am not sure if I am asking this
question correctly. But here goes. I have three reports with a common
relationship (one-to-many) and would like for my report to group a section of
information from each sub-report.
When I put all three reports into a master I end up with each report
following the other.
Report 1 contains Milestones by team with information
Report 2 contains Issue by team with information
Report 3 contains Risks by team with information
What I need is
Milestone team one information
Issue team one information
Risk team one information
Milestone team two information
And so on
“Is there anyway to sort three sub-reports together inside of a master
report?â€

Any help would be greatly appreciated.

 

[Marshall Barton]

. I have three reports with a common
relationship (one-to-many) and would like for my report to group a section of
information from each sub-report.
When I put all three reports into a master I end up with each report
following the other.
Report 1 contains Milestones by team with information
Report 2 contains Issue by team with information
Report 3 contains Risks by team with information
What I need is
Milestone team one information
Issue team one information
Risk team one information
Milestone team two information
And so on
“Is there anyway to sort three sub-reports together inside of a master
report?”

One to many relations are commonly presented with the main
report based on the one side table/query and the subreports
based on a many side table/query. The subreport control's
Link Master/Child properties are used to connect the related
data together the way you want.

 

[Duane Hookom]

You can use the Link Master/Child properties to link each subreport to the
Team from the main report.

 

[Guest]

Thank you so much for the quick response. Is there any where I can go on line
that will give me a step by step on how to set up a master child link?

 

[Duane Hookom]

I expect you may have already used this on forms with subforms. You just
have to set the proper field names in the Link Master and Link Child
properties of the subreport control. There is even a "wizard" that you can
use.