Detail Section of Report

[Guest]

It might just be a limitation of MS Access, but I hope a there is a solution
that I'm just not seeing to this issue.

I have a 2 tables - both with a memberID which allows a relationship to be
created.

1st Table) Contains information about individuals.
2nd Table) Can contain more than one memberID -- each row has infomation
about the person's children.

I would like to create a report that lists the person's children. I've got
it set up so that in the 'detail' section, each child is listed on a
different line. So, right now it looks like:

memberID: xxx Name: xxx Age: xxx (grouping level)
Sarah
(detail section)
Michael
William

I would like to combine all the children onto one line: i.e.

memberID: xxx Name: xxx Age: xxx (grouping level)
Children: Sarah, Michael, William (detail section)

And is it possible to do everything on one line?:

memberID: xxx Name: xxx Age: xxx Children: Sarah, Michael,
William

Thanks for your help!

 

[Douglas J. Steele]

See whether the code in http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" helps.

 

[Duane Hookom]

Another generic concatenate function with sample usage can be found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Thank you, Duane Hookom. You do great.

 

[Guest]

Thank you, Doug! I used both modules of code in different situations. Well
done! I appreciate your help.