Quick Question

[SageOne]

I need to turn this record set....

Column 1 Column 2
Team A Tim
Team A Joe
Team A Bob

Into this record set......

Column 1 Column 2
Team A Tim Joe Bob

I need to group Team A and then place Tim Joe Bob in one cell.

 

[Gina Whipp]

SageOne,

I just answered this... Here we go again...
http://allenbrowne.com/func-concat.html

Please try not to multi-post. We are volunteers and it's not fair to wasted
time answering questions twice you take away from someone else.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tom van Stiphout]

On Tue, 22 Sep 2009 20:50:01 -0700, SageOne

Maybe you can adjust this for your purposes:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.
Microsoft Access MVP