Concatenate 3 fields from Table 1

[neepshed]

How can I join 3 fields from a single table together. I intend putting the result into a temporary table.

e.g.
Table 1
Field1
Field2
Field3

Output
Field1,Field2,Field3

Thanks in advance.

 

[HarleyQuinn]

If your fields are rows this (faq701-4233) should be useful.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[dhookom]

If the field values are from the same record, use something like:

SELECT Field1 & "," & Field2 & "," & Field3 As ThreeFields
FROM [Table 1]

Duane MS Access MVP
Now help me support United Cerebral Palsy