Steve
Access has a Replace() function That will do the trick.
UPDATE myTable
SET myField = Replace([]myField],"xxx","yyy")
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 21, 2015 1:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Update query to find and replace
I'm using Access 2007. Have a table in which I need to update a memo
field. Each record's memo field is different but they all have a
character string xxx which I want to replace with yyy. I have developed
a query to select the records in need of changing, but I am at a loss as
to how to use an update query to find xxx and replace with yyy. Advice
appreciated.
Thanks.
Steve
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar