N
NeonSky via AccessMonster.com
Good Afternoon,
Would anyone know how to do the following? First please view my sample
dataset....
Name Address Phone TransNumber
Joe 64 Lane 123 45
Joe 64 Lane 123 92
Sam 24House 456 87
Sam 24House 456 21
I would like an output that performs a "group by" on the like data, and
concatenates/formats the differing data from the same field....So the output
would look like this....
Name Address Phone TransNumber
Joe 64 Lane 123 45, 92
Sam 24House 456 87, 21
Thanks for your consideration!
Would anyone know how to do the following? First please view my sample
dataset....
Name Address Phone TransNumber
Joe 64 Lane 123 45
Joe 64 Lane 123 92
Sam 24House 456 87
Sam 24House 456 21
I would like an output that performs a "group by" on the like data, and
concatenates/formats the differing data from the same field....So the output
would look like this....
Name Address Phone TransNumber
Joe 64 Lane 123 45, 92
Sam 24House 456 87, 21
Thanks for your consideration!