Hi Harry,

You can add notes to the existing comments field and remove notes field after that.

REPLACE ALL comments with Notes + Chr(13)+ Chr(10) + Comments

It would be a good idea to make a backup copy of the table before doing that.

>I'm trying to re-structure a table that has a 254-byte notes field and a memo comments field. I need to combine these two into one memo field, IE:
>
>lmNewMemo = lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>
>The "lmNewMemo" field contains just the old memo field.
>
>Any suggestions?
>
>Thanks,
>
>Harry