Total Query: Sum of Strings

[budder8818]

Hi,

I am trying to create a query like this:



Given the table on the left, I want to get the query on the right:



Is this possible. I think it is analogous to a totals sum query except we are adding strings instead of numbers.

[burrina]

Please explain in plain English what exactly it is your trying to do!

[ItsMe]

I think the OP wants to concatenate the field with TX from various rows to a single string.

[lfpm062010]

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.

[June7]

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.

[budder8818]

Thank you. I will try and test this code out. The data was for illustrative purposes.