concatanating values of one column

[igowhari]

Hi
How can I concatanate values of one column in a query. for example

data:
ID Text
1 A
1 B
1 C
2 A
2 D

result:
1 ABC
2 AD

Thanks

 

[Marshall Barton]

Hi
How can I concatanate values of one column in a query. for example

data:
ID Text
1 A
1 B
1 C
2 A
2 D

result:
1 ABC
2 AD

You need to create a function to do that. There's a good
one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[David F Cox]

A crosstab query will do something similar, and may be able to do what you
need and more.

 

[AccessDB.Info]

Concatenating unique field values for records matching a query's GROUP BY
clause
http://www.accessdb.info/content/view/102/40/

 

[Van T. Dinh]

See Also The Access Web article:

http://www.mvps.org/access/modules/mdl0008.htm