concatenate field in all records

[Nicholas R. Markham]

I'm looking for a way to concatenate the contents of a given field for all
records in a table. The idea is similar to summing a column of numbers, if
one thinks of concatenation as a kind of string addition. AFAIK there is no
SQL aggregate function that does concatenation; does anyone know of a way to
do it? Thanks.

 

[Van T. Dinh]

Try the method used in The Access Web article:

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

 

[Duane Hookom]

Another solution with a sample is at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.