Multiple detail sections

[NevilleT]

I seem to remember setting up multiple detail sections for a report or form
in another Access database but cannot remember how I did it. Basically I use
one or more detail sections depending on some critieria when I open the
report. Googled it but no success. Can anyone confirm it can be done, and
let me know how?
Thanks

 

[Larry Linson]

I seem to remember setting up multiple detail sections for a report or form
in another Access database but cannot remember how I did it. Basically I
use
one or more detail sections depending on some critieria when I open the
report. Googled it but no success. Can anyone confirm it can be done,
and
let me know how?

Reports support multiple Group Headers and Footers, but only one Detail
Section. If you want multiple Detail Sections in the same Report, you can
include Reports in Subreport Controls. How much "sense" it will make depends
on how your data is related.

Larry Linson
Microsoft Access MVP

 

[NevilleT]

Thanks Larry. It was more a curiosity thing. I have accomplished the same
thing using subreports in the report footer. I had a report with up to 5
rows of data(month and year details). If there was only 3 rows of data to be
displayed, I wanted to show only the 3 subreports or detail sections and hide
the other 2. Can be easily done with subreports. It is interesting though
to think of a collection of detail sections. Thanks for responding.

 

[Rick Brandt]

Thanks Larry. It was more a curiosity thing. I have accomplished
the same thing using subreports in the report footer. I had a report
with up to 5 rows of data(month and year details). If there was only
3 rows of data to be displayed, I wanted to show only the 3
subreports or detail sections and hide the other 2. Can be easily
done with subreports. It is interesting though to think of a
collection of detail sections. Thanks for responding.

If you create a group header and/or footer on a field or combination of fields
that are unique across all rows of the report's RecordSource you will have a
section that behaves much like a second or third detail section.