Query Question

[sdc1234]

Greetings, I am trying to eliminate the /B from E/L/B 201, Instead of doing multiple queries to get rid of the /B, Is there an easier way of going about this in 1 query?

V/R
Novice

[JoeM]

Use the REPLACE function, i.e.:

Replace([Field1],"/B","")

For more information on this function, see: http://www.techonthenet.com/access/f...ng/replace.php

[sdc1234]

Thank you that worked