how to list all records in a field (1 Viewer)

[btrflym]

hi,
In a table, i have the following information:
ConvNo FSIAttendee
31001 John
31001 Doug
31002 Meg
etc...

I have a report that runs from a parameter query where you enter the convention number.
How do I make the report for ConvNo 31001 read as:
FSI Attendees: John
Doug
this is in the middle of the details section of the report along with a lot of other information. As it is running now, it is printing a separate page for each attendee entered.

Thanks,
Meg
btrflym@aol.com
601-354-3565

 

[TexasTJ]

There is a function someone wrote I believe called fConcatChild that does what you want. Try out this page of the Access Web:
http://www.mvps.org/access/modules/mdl0004.htm

Good luck!

 

[llyal]

Try experimenting with subreports; this is the trick when making reports that have different formatted sections; example, main report lists convention info, subreport lists all attendees for associated convention;