>>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
>
>Harry,
>Try :
>replace lmNewMemo with lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>
>Cetin
BTW they're not actual field names I think :
replace (lmNewMemo) with eval(lcOldCharField) + ;
Chr(13)+ Chr(10) + eval(lmOldMemoField)
Cetin