does it really workks Edy WIYONO <[EMAIL PROTECTED]> wrote: 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] --------------------------------- 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here. [Non-text portions of this message have been removed]
