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.

Thanks

 

[Rick Brandt]

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.

Thanks

Put your subreports into a section that only runs once like the Report header or
footer.

 

[Joseph Meehan]

I have multiple pieces of unrelated data that I am trying to compile into
one
report.

I think that is your problem, that is that one word "unrelated"

You are going to need to be more specific about the data and what you
want to do, but you need to be able to tell Access exactly what you want on
the report, and that would be very difficult if you are trying to display
unrelated data.