Include all cells in a column/field in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Thanks

KARL DEWEY said:
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]
Click to expand...
 
Back
Top