Please explain in plain English what exactly it is your trying to do!
I think the OP wants to concatenate the field with TX from various rows to a single string.
You are trying to concatenate all the "TX" (comma delimited) that has the same name.
It is easier to do it in VBA and create a temp table to store your result.
One to do this is use VBA, get the record set (sorted by name and TX).
Then compare name and concatenate "TX" string for the same name.
Why even bother saving the TX into data? Are any other characters ever used?
To get the first right hand example, refer to http://allenbrowne.com/func-concat.html
Your second right hand example makes no sense considering the data on the left.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you. I will try and test this code out. The data was for illustrative purposes.