How to SELECT fields values from a table as cocatenated string

[Shalash]

Kindly advise me how to SELECT fields values from a table as cocatenated
string?

 

[Warrio]

Hi Shalash,

Create a query and go to Sql view and type:

SELECT Field1 & Field2 AS myStr FROM Table1

the symbol & is used for this purpose