How can I print grouped records on one line? 1

[happybunnyj]

I have an Access report that lists DVD titles and the speakers associated with each. I'm grouping by each DVD and listing each speaker underneath. My problem is each speaker is starting on a new row. I've TRIED columns, but I can only fit 2 on a page and it looks crazy with the names spaced so far apart. Can someone please help me with produce a report using the following as an example?

DVD Title One

Doe Jane, Doe John, Smith Jane, Smith John, (etc...)

What I CURRENTLY get is:

DVD Title One

Doe Jane
Doe John
Smith Jane
Smith John (etc...)

Thanks much. I've been trying to figure this out for weeks!

 

[dhookom]

There are two main options. One is to remove the names from the main report and place them in a multiple column subreport. The other option is using the generic concatenate function found in the Query Forum FAQs here or at generic function to concatenate child records

Duane
Hook'D on Access
MS Access MVP