combining field contents

[jiminy]

Is there a way to combine 2 text fields in a table to make a third in the same table?
Example for one record:
Field1 = 1
Field2 = a
Field3 = 1a

 

[sxschech]

You can use & to concatenate the fields together.

Select Field1, Field2, Field1&Field2 AS Field3
From table;