Memo Field - Append Text fields into memo field???

[Pat Stewart]

I have two tabels - one (1) with client data and a memo field that acts as
the Address Block (for Mailing, merge etc)

The other table (2) has client info that I want to merge/append into the
above table. In this other table, the fields which I want to append are text
fields that represent the address i.e add1,add2,add3,city,state,zip.

How can I take the text fields in Table (2) and append them into table 1
memo field..

Gzzz, I hope this is clear....

 

[storrboy]

I have two tabels - one (1) with client data and a memo field that acts as
the Address Block (for Mailing, merge etc)

The other table (2) has client info that I want to merge/append into the
above table. In this other table, the fields which I want to append are text
fields that represent the address i.e add1,add2,add3,city,state,zip.

How can I take the text fields in Table (2) and append them into table 1
memo field..

Gzzz, I hope this is clear....

This depends on wether or not there is a common key field.
If so create an update query with the appropriate joins and criteria
and set the memo field to be a concatenation of the other fields.
Example...
UPDATE tableList SET tableX.MemoField= tableY.add1 & chr(13) & chr(10)
& tablY.add2........

Add any other criteria or joins you need to