Combine records into paragraphs

[journeyman]

Hi All,



I am not sure how to approach this problem. please bear with me.

I am attempting to collect multiple records into a single query, then output that query to a word document as text.

---------------
Apple
---------------
Orange
---------------
Pear
---------------

Into

Apple
Orange
Pear

I suppose I could do a vba loop, but is there a way to write a query that would do this in one stroke?

[Gicu]

You should look into using a VBA concatenation function, I think the easiest to use in your case is theDBGuy's SImpleCSV():
http://www.accessmvp.com/thedbguy/co...itle=simplecsv

Cheers,
Vlad

[Micron]

You'd need code to run the query and output it using rtf format I think.
https://learn.microsoft.com/en-us/pr...3(v=office.11)