another update question

  • Thread starter Thread starter mcnews
  • Start date Start date
M

mcnews

can i create a query that will append a value to a field?
i have a table that contains a large text field that i would like for
data from another table to be appended to.
table A has a unique ID field.
table B may have 0 or many records with the same ID field.
i want the contents of fieldX from table B to be appended to fieldQ of
table A for each matching record.
can this be accomplished with an UPDATE query?

thanks again in advance,
mcnewsxp
 
Sure can, copy and paste this in a query in sql mode and modify it to handle
you tables:

UPDATE TableA INNER JOIN tableB ON TableA.ID = tableB.ID SET TableA.fieldq =
[TableA]![fieldq] & [tableB]![fieldX];
 
Back
Top