Concatenating a COLUMN of data from a Subform Query to a Field in Parent form.

[gene_yuss]

Is there a way to concatenate a COLUMN of data from every record in a Subform (that is based off a Query) to a Field in parent form after a button is pressed?



Any help/Links would be appreciated. Really, I just don't know how to concatenate a column instead of fields one record.

[pbaldy]

How about

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

http://allenbrowne.com/func-concat.html

[gene_yuss]

Thanks pbald I apprecaite it GREATLY! This is exactly what I have been searching for!

[pbaldy]

Happy to help!