MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Concatenating fields in MS Query


Posted by Lee Obbard on January 30, 2002 8:22 AM

Do you know of a way to concatenate fields in MS query. I have tried using SQL (from the tool bar) and the syntax + , but no luck. Please Help


Posted by Mark W. on January 30, 2002 8:31 AM

Which driver are you using? Text? Oracle? [nt]

Posted by DK on January 30, 2002 8:58 AM

Hello Lee,

In the SQL editor use this syntax:-

SELECT [tableName.Field1] & [tableName.Field2] AS [Your new field name] FROM your data source

HTH,
D