concatenated multi row text in single column

[thirumurugan]

hi,

pls help how to concatenated multi row text in single column via VBA Code
i have attached text.dbs file whats my requirement

pls help provide with samble database with VBA CODE



:banghead::banghead::banghead::banghead::banghead:

 

[pbaldy]

You can adapt this:

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

using a vbCrLf instead of a comma.