How do I compile data in different rows and output to a new column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jose G Morales - 15 Sep 2006 04:21 GMT

for the sake of simplicity, This Table has a column for names and a column
for seating assigments,
Joe, table1
Mary, table1
Peter, table2
Frank, table2
I want to output as follows:
table1, Joe and Mary
table2, Peter and Frank
I know it could be done, please shed some light on my old brain
thanks.

Reply to this Message

Marshall Barton - 15 Sep 2006 05:22 GMT

>for the sake of simplicity, This Table has a column for names and a column
>for seating assigments,
[quoted text clipped - 6 lines]
>table2, Peter and Frank
>I know it could be done, please shed some light on my old brain

You need to create a function to do that. There's a good
one at:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Signature

Marsh
MVP [MS Access]

Reply to this Message

Jose G Morales - 17 Sep 2006 23:58 GMT

That was very helpful and I was able to adapt it to my table.
thank you very much

> >for the sake of simplicity, This Table has a column for names and a column
> >for seating assigments,
[quoted text clipped - 10 lines]
> one at:
> http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Reply to this Message

Marshall Barton - 18 Sep 2006 01:03 GMT

You're welcome, but Duane, deserves all the credit for
creating the function and making it available to the rest of
us.

Signature

Marsh
MVP [MS Access]

>That was very helpful and I was able to adapt it to my table.
>thank you very much
[quoted text clipped - 13 lines]
>> one at:
>> http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Reply to this Message