Combine fields from different tables

[Jen0dorf]

Hi

I have two tables both of which have a field called inscription.

I'd like to merge the two fields

ie if one field is AB and the other cd I'd like to change it to ACBD in the first table

I tried an update query but that overwrites the field.



I think I have two options.

1. Concatinate the fields

2. Export the tables to excel where I can copy and paste the 2nd colum to the 1st table and then easily combine the fields. I would then import the table into my database as a new table and then run an update query.

THis seems a bit long winded is there a better way?

thanks

Ian

[RuralGuy]

How about a query that concatenates the two fields, then an update query that updates the field you want from the 1st query's concatenated field?

[ssanfu]

Or maybe VBA to concatenate the fields.....???