Multiple Detail Sections in one Report

[Guest]

I have multiple pieces of unrelated data that I am trying to compile into one
report. I acquire the data using a Microsoft Excel web query, on about 10
worksheets. I was trying to then link the data into Access tables to create
the reports, as parts of the information are variable in the number of lines
(Logbooks which vary in number of entries, etc.). If I could create multiple
detail sections in an Access report, that would solve the problem. I have
tried pulling sub reports into the detail section, however the sub report is
repeated after each line of the main report entries. Is there a way to
accomplish what I am trying to do in Access? I am a beginner with Access.

 

[Pat Hartman]

There can be only one detail section for a report. The detail section will
be "printed" for each record of the report's RecordSource. You can put
subreports in any of the report's sections. If they don't work for your
purpose in the detail section, put them in the ReportFooter which is printed
only once at the end of the report. If you want something in between, use
the report's sorting and grouping dialog to add sections to the report.