Ms Access replace issue and automated process

Asked By Robert K Harrington 10 points N/A Posted on - 10/21/2014

Update a database with 6000 duplicate rows. Duplicates are companies who all share a number of common codes. My problem is that I am trying to replace one or two areas at a time. That’s all that needs to be replaced. I just need to know if have automated the process of how. I know I could write code to do this, if the value to zero by 2010, it must be replaced. Any help would be great. I’ll be there if you need more information about the problem.

• Status: Open
• Question Views: 683
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office

Answered By Darry Hunt 0 points N/A #188295

Ms Access replace issue and automated process

You can simply try the built-in Replace function in MS Access to Find and Replace the words you are in need to be replaced.

Also you can use an Update Query, in the "Update To" row.

(Actually the details you have provided is not clear. But as much as I understood, the code can be written as follows:)

• Replace([NameField],"0","2010")

At the end, it is possible to call or run this query from the macro. 

About Darry Hunt

Questions
0

Answers
100

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/29/2015
• Question Category: Microsoft Office