ACCESS FEED: Re: [MS_AccessPros] Update query to find and replace

Senin, 24 Agustus 2015

Re: [MS_AccessPros] Update query to find and replace

Thank you Bill. That did the trick.

Steve

On 8/22/2015 2:13 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:

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

http://wrmosca.wordpress.com

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