Replace two fields into one

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

Guest

I have three fields (all three text) in a table "a1", "a2" and "a3"
How can put all for a1 Plus (combine) a2 into a3 with a query?
Thanks
 
Try this

Select a1,a2,a3,a1 & " " & a2 & " " & a3 as CombineA From TableName

I added a space between the fields, if you dont want the space then

Select a1,a2,a3,a1 & a2 & a3 as CombineA From TableName
 
I put this into the query as an SQL statement:
Select Table1.a1,table1.a2,Table1.a3,Table1.a1 & Table1.a2 & Table1.a3 as
CombineA From Table;
I get:
Syntax error (missing operator) in query expression '& Table1.a2 & Table.a3'
 
Back
Top