Multiple Replacements in a query

[Guest]

I am using this string: Itinerary: Replace(

,"-"," ")
To make my results look like this: "abc rtb ghe" rather than this
"abc-rtb-ghe"

I also have some slashes in the results eg. abc/def. Can I replace both the
"-" and the "/" with " " in the same query?

Thanks

 

[Douglas J. Steele]

Replace(Replace(

,"-"," "), "/", " ")

 

[Guest]

Thanks, Doug for answering this question. Great web-site too. In case it
helps, tell your wife that your time on the access boards helps complete
strangers stay sane!
Regards, Dave
--

Replace(Replace(

,"-"," "), "/", " ")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am using this string: Itinerary: Replace(

,"-"," ")
To make my results look like this: "abc rtb ghe" rather than this
"abc-rtb-ghe"

I also have some slashes in the results eg. abc/def. Can I replace both
the
"-" and the "/" with " " in the same query?

Thanks