I Indep99 Registered User. Local time Today, 00:11 Joined Dec 21, 2011 Messages 23 Jan 6, 2012 #1 Hi, I am trying to combine a few columns in a query but I would like it to the "enter" function added in between each column so for example A b c Text 1 text 2 text 3 result: Text 1 Text 2 Text 3
Hi, I am trying to combine a few columns in a query but I would like it to the "enter" function added in between each column so for example A b c Text 1 text 2 text 3 result: Text 1 Text 2 Text 3
G Galaxiom Super Moderator Staff member Local time Today, 17:11 Joined Jan 20, 2009 Messages 12,895 Jan 6, 2012 #2 In the Field box of the query designer: Code: SomeName:[Field1] & Chr(13) & Chr(10) & [Field2]