CONCATENATE in access

[ylivne]

Hi
I have a table that goes like that:
#, Index, Text
1, 11111, aaaa
2, 11111, bbbb
3, 11111, gggg
4, 44444, tttt
5, 66666, kkkk
6, 66666, hhhh

and I need this:
11111, aaaa bbbb gggg
44444, ttttt
66666, kkkk hhhh

In other words I need CONCATENATE in access.
Can you assist?

Thanks
Yael

 

[KenHigg]

I think you're going to have to do something like the sample in post #5 in the following thread:

Link

 

[ylivne]

Hi Ken
It worked perfectly.
Thanks

 

[KenHigg]

Glad you have it working -

 

[ylivne]

Hi
Can I activate the event from a report or do I have to create a form in order to run it?