merge one field from one table with another feild in a difrrent table

[cslr]

what is the best way to do this ..merge one field from one table with another feild in a difrrent table to a new field
like to thank everyone for any help they can give

[alansidman]

Join the two tables in a query on a common field. What do you mean by merge? Concatenate? Add?

[cslr]

i think it is Concatenate is that when you take the data from one feild then data from anouther feild from a diffrent table and make a new field with the data from both field
eg table1 field1 (123) table2 feild1 (456) = field2 123456
thanks for any help you can give i am very new to all this

[alansidman]

Join your two tables on a common field. In a new field, type the following

NewFieldName: [table1].[Field1] & [table2].[Field2]

Change the names to reflect your table and field names.