Ms Access replace issue and automated process
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.