Retrieving data from multiple records

[Serendipity]

How do I put data from multiple records in one report on one line. I have
parents in one table and children in another. Each child has its own record.
How can I include a sentence like this in a report when the children's names
come from various records: "Thank you for registering Brianna, Sean, and Emma
for our art workshop." Also, there are other children in the family who were
not registered. Using Access 2003.

Thanks for your help.

 

[Duane Hookom]

There is a generic function that will concatenate the child records at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16&SID=ea4f7bb7azc4z6ebf9z5ae4b33d1961z.

 

[Serendipity]

Thanks. That was what I needed.

There is a generic function that will concatenate the child records at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16&SID=ea4f7bb7azc4z6ebf9z5ae4b33d1961z.