Multiple Detail Sections in one Report

B

Big Poppy

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
 
R

Rick Brandt

Big said:
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
Click to expand...

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