another update question

[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

 

[NthDegree]

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];