Ms Access replace issue and automated process

Asked By 10 points N/A Posted on -

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.

Answered By 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. 

Login/Register to Answer

Related Questions