I have a master record with 3 separate detail records that I'm trying to create a report on. I using the wizard (group above) template. The problem that i'm getting is in the data modal, the grouping is that detail1 is grouped to the master. detail2 is grouped to detail1 and detail3 is grouped to detail2. I need all 3 details grouped directly to the master. What am i doing wrong.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
master with multiple details report
- Thread starter wdc58
- Start date
This report can not be created with Wizard.
In the data model, create separate queries for master recordset and for each detail section. Link detail queries to master query by appropriate fields.
In the layout section create repeating frame for the master group, and inside that separate repeating frames for each detail recordset.
In the data model, create separate queries for master recordset and for each detail section. Link detail queries to master query by appropriate fields.
In the layout section create repeating frame for the master group, and inside that separate repeating frames for each detail recordset.
- Thread starter
- #3
- Status
Similar threads
