Concatenate Rows

[Guest]

Thanks for taking the time to read my question.

I'm wondering how I can concatenate Rows together (not columns).

Current Data:

Name Child Name
Bob Jane
Bob Jon
Bob Sandy
Bob Derek

Goal:

Name Child Name
Bob Jane, Jon, Sandy, Derek

I can't figure out how to do this! Any ideas?

Brad

 

[Brian Bastl]

Brad,

take a look at the following. It will do what you want.
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

Brian

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Guest]

Hi Brian,

That link didn't work for me. Is it correct? Is there another way to get
to it?

eg. Click here, then click here etc...

Brad

 

[Brian Bastl]

Brad,

go to:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

and then click on 'General Function To Concatenate Child Records'

HTH,
Brian

 

[Guest]

Thanks so much Brian, this code works on many records, not just one. It
worked Perfectly. Thanks to Duane Hookom too!

Brad

 

[Duane Hookom]

You are welcome....