Multiple detail sections in a report

[Gazza]

Hey Guys,

This one has got me puzzled.

Short Question:
Is it possible to create multiple *detail* sections within a single
report in Access?

Long Question:
It is possible to create multiple sections, by sorting and grouping -
however, these only allow extra headers and footers, and NOT detail
sections. It creates something like this:

<page header>
<status header>
<numeracy header>
<literacy header>
<status details>
<literacy footer>
<numeracy footer>
<status footer>
<page footer>

Whereas I'm after something like:

<page header>
<status header>
<status details>
<status footer>
<numeracy header>
<numeracy details>
<numeracy footer>
<literacy header>
<literacy details>
<literacy footer>
<page footer>

....where each of the details sections are drawn from queries which group
and count the unique entries for student status, Numeracy level and
Literacy Level. The queries work fine, and adding the queries to the
reports RecordSource is no problem, but I can't seem to achieve the
section breaks I'm after - only nested grouping.

Any ideas?

 

[Guest]

Maybe you could create use sub reports?

 

[Marshall Barton]

Short Question:
Is it possible to create multiple *detail* sections within a single
report in Access?

Long Question:
It is possible to create multiple sections, by sorting and grouping -
however, these only allow extra headers and footers, and NOT detail
sections. It creates something like this:

<page header>
<status header>
<numeracy header>
<literacy header>
<status details>
<literacy footer>
<numeracy footer>
<status footer>
<page footer>

Whereas I'm after something like:

<page header>
<status header>
<status details>
<status footer>
<numeracy header>
<numeracy details>
<numeracy footer>
<literacy header>
<literacy details>
<literacy footer>
<page footer>

...where each of the details sections are drawn from queries which group
and count the unique entries for student status, Numeracy level and
Literacy Level. The queries work fine, and adding the queries to the
reports RecordSource is no problem, but I can't seem to achieve the
section breaks I'm after - only nested grouping.

No, you can not have multiple details, but you may be able
to fudge the grouping to get that effect.

OTOH, what you described sounds more like you want to use
three subreports to organize the data.