Multiple Replacements in a query

I am using this string: Itinerary: Replace([TABLE],"-"," ")
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

Replace(Replace([TABLE],"-"," "), "/", " ")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"AccessNewbie" wrote in message
...
I am using this string: Itinerary: Replace([TABLE],"-"," ")
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

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
--


"Douglas J. Steele" wrote:

Replace(Replace([TABLE],"-"," "), "/", " ")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"AccessNewbie" wrote in message
...
I am using this string: Itinerary: Replace([TABLE],"-"," ")
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