Include all cells in a column/field in a query

[Guest]

How do I query all cells or the whole column of a field in a table into one
cell? I will then export the newly created table for use in a Word merge.

 

[Guest]

That is never going to work.
What are you actually trying to do?

 

[Guest]

Duane Hookom has a good solution --
Generic Concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

If you are using the ADO code, try change the "*" to "%".
=Concatenate("SELECT Email FROM ConcatenateEmailsTable WHERE LIKE
'%.com' ")

 

[Guest]

Thanks

Duane Hookom has a good solution --
Generic Concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

If you are using the ADO code, try change the "*" to "%".
=Concatenate("SELECT Email FROM ConcatenateEmailsTable WHERE LIKE
'%.com' ")

--
Duane Hookom
MS Access MVP

Or just copy the datasheet field and paste special, Unformated Text in Word.

[QUOTE="dlz"]
How do I query all cells or the whole column of a field in a table into one
cell? I will then export the newly created table for use in a Word merge.[/QUOTE][/QUOTE]