Trouble Creating a Report with Memo Fields that are grouped

[startup]

Hello,

I have a table that has a layout like this:
CourseID(Text)|UserID(Text)|Paragraph1(Memo)|Paragraph2(Memo)

What I want is to get a report in this format, but I'm not sure how:

CourseID1
Heading Label for Paragraph1
User1 - Paragraph1 - blah, blah...
User2 - Paragraph1 - blah, blah...
User3 - Paragraph1 - blah, blah...
Heading Label for Paragraph2
User1 - Paragraph2 - blah, blah...
User2 - Paragraph2 - blah, blah...
User3 - Paragraph2 - blah, blah...
<Next Page>
CourseID2...

I think it is something with subreports in the Details area of the main report which is grouped on the CourseID, but the subreports seem to split things into multiple pages where it should only be one page or do other odd things. Any ideas for how to create this report?

Rico

 

[startup]

Some more information:

The closest I can get with the report is like this. It keeps repeating the Heading label again for each user, which I don't want. I have the CourseID in a header. Then in the Details section I have the Heading Label and a subreport underneath that displays the memo paragraphs.

CourseID1
Heading Label for Paragraph1
User1 - Paragraph1 - blah, blah...
Heading Label for Paragraph1
User2 - Paragraph1 - blah, blah...
Heading Label for Paragraph1
User3 - Paragraph1 - blah, blah...
Heading Label for Paragraph2
User1 - Paragraph2 - blah, blah...
Heading Label for Paragraph2
User2 - Paragraph2 - blah, blah...
Heading Label for Paragraph2
User3 - Paragraph2 - blah, blah...
<Next Page>
CourseID2...

 

[dhookom]

I think you can create a main report based on a query like:
SELECT CourseID
FROM tblYourTable
GROUP BY CourseID;

The create subreports based on the user and paragraph pairs. Use the link master/child with the CourseID field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[startup]

Thanks Duane,

The GROUP BY was exactly what I needed on the main report. The Subreports were still causing a problem when I used the subreport wizard tool to create them. But then I manually created them as separate reports by themselves and then dragged and dropped them onto the main report and everything worked perfectly.

Rico