May be you can try this: Replace(Replace([PartNum],"-",""),"/","")
I hope it work. ----- Original Message ----- From: mikeuhd To: [email protected] Sent: Saturday, November 10, 2007 01:15 Subject: [ms_access] MS Access replace function I have a part number field with numbers and characters. for example i have a part number 457-67a/12. i want to repalce the ,"-" and "/", with empity string using the replace function. replace([partnum], "- ", "") only replaces the "-". how do i place multiple parameter in this function. Thanks . [Non-text portions of this message have been removed]
