E
Earl.AKA J.Alladien in access forum!!
Hi all,
How do I do a replace/Update qry where just a certain part of text in a memo
field gets replaced by a value in another field from the same table fe:
Name e-mail
message(memo field)
marco wongso (e-mail address removed) "DEAR #NAME#,
U ARE THE BEST!
*becomes*
marco wongso (e-mail address removed) "DEAR marco wongso,
U ARE THE BEST!
Mikal Jordan (e-mail address removed) "DEAR #NAME#,
U ARE THE BEST!
*becomes*
Mikal Jordan (e-mail address removed) "DEAR Mikal Jordan,
U ARE THE BEST!
Is this possible?Please advise and thanks in advance!
How do I do a replace/Update qry where just a certain part of text in a memo
field gets replaced by a value in another field from the same table fe:
Name e-mail
message(memo field)
marco wongso (e-mail address removed) "DEAR #NAME#,
U ARE THE BEST!
*becomes*
marco wongso (e-mail address removed) "DEAR marco wongso,
U ARE THE BEST!
Mikal Jordan (e-mail address removed) "DEAR #NAME#,
U ARE THE BEST!
*becomes*
Mikal Jordan (e-mail address removed) "DEAR Mikal Jordan,
U ARE THE BEST!
Is this possible?Please advise and thanks in advance!