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

[Guest]

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.

 

[Marshall Barton]

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

You need to create a function to do that. There's a good
one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[Guest]

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

 

[Marshall Barton]

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