How to append two memo fields

[State]

I have two tables that each contain a memo field. I would like to know if it is possible to have an append query that only appends the contents of the one memo field in the one table to the contents of the other memo field in the second table. Thank you.

 

[OSCSLeo]

you can construct a query that concantenates both memo fields then append it to the table you want to add it to.

HTH