Concatenate Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 08 Mar 2006 16:07 GMT

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

Reply to this Message

Brian Bastl - 08 Mar 2006 16:23 GMT

Brad,

take a look at the following. It will do what you want.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Brian

> Thanks for taking the time to read my question.
>
[quoted text clipped - 16 lines]
>
> Brad

Reply to this Message

Brad - 08 Mar 2006 16:48 GMT

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

> Brad,
>
[quoted text clipped - 23 lines]
> >
> > Brad

Reply to this Message

Brian Bastl - 08 Mar 2006 16:55 GMT

Brad,

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

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

HTH,
Brian

> Hi Brian,
>
[quoted text clipped - 8 lines]
> >
> > take a look at the following. It will do what you want.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

> > Brian
> >
[quoted text clipped - 18 lines]
> > >
> > > Brad

Reply to this Message

Brad - 08 Mar 2006 17:39 GMT

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

Brad

> Brad,
>
[quoted text clipped - 43 lines]
> > > >
> > > > Brad

Reply to this Message

Duane Hookom - 08 Mar 2006 20:25 GMT

You are welcome....

Signature

Duane Hookom
MS Access MVP
--

> Thanks so much Brian, this code works on many records, not just one. It
> worked Perfectly. Thanks to Duane Hookom too!
[quoted text clipped - 49 lines]
>> > > >
>> > > > Brad

Reply to this Message

Allen Browne - 08 Mar 2006 16:31 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for taking the time to read my question.
>
[quoted text clipped - 16 lines]
>
> Brad

Reply to this Message