DevilDog78
4-21-09, 10:34 AM
Please forgive me if this is not the correct place to post a question. I am new to Access and I am trying to fix an old database at work. The problem is the "part_nbr" field in the "standards_t3" table contains special characters. I want Access to take out any character that is not alphanumeric. I have tried using the following replace command:
Replace(Replace(Replace(Replace(Replace([part_nbr],"-",""),"/",""),"\",""),",",""),".","")
When running a query this command seems to delete records. Is there an easy way to do this? Please keep in mind that I am a "newby". Any help would be greatly appreciated.
Replace(Replace(Replace(Replace(Replace([part_nbr],"-",""),"/",""),"\",""),",",""),".","")
When running a query this command seems to delete records. Is there an easy way to do this? Please keep in mind that I am a "newby". Any help would be greatly appreciated.