Remove "\" from data in Ms Access table.

donnie91910
donnie91910 used Ask the Experts™
on
I need a query to remove "\" from data in MS Access table.  Table name is "TMC" and the field name is "Org".
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
try use Replace function

Update TMC set Org = replace(Org, "\", "")

Open in new window


MS Access: Replace Function
https://www.techonthenet.com/access/functions/string/replace.php

Author

Commented:
Actually it was a forward slash "/".  This is what worked: Expr2: Replace([Expr1],"/","").  Thanks very much.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial