Add field in query

L

lyric2002

I need to add a new field in a new table based on concatenating two existing
fields. I don't want to use an update table as this process will be run on a
weekly basis and is included in a macro.

What would the syntax be to add a new field in the design view of a make
table query? Is it possible?

TIA
 
O

Ofer

If you want to add another field that contain the value of two other existing
fields, its a wrong move, youll have to maintain it and it can cause alot of
mistakes.
Instead create a query that list all the fields in the table, together with
another field that join the other two fields

Select Field1, Field2, Field3, Field1 & " " & Field2 as Field4 Form TableName.

That way you wont have to maintain this field, and it will apear as an extra
field
 
Top