Remove Multiple characters from field

[gkrenton]

I've seen thread181-183305 & read it trying to understand how I can remove both a & and a ; from a field.
I'm trying to remove the html code in a web link that I'm creating in my query.
What I have thus far is

url: "

http://www.mysite.com/"

& Replace([short_description],"&","") & "-p" & [inv_id] & "c0-path0.html"

Which removes the & from the ® part of the html within the short_description field. BUT I also need to remove the semi-colon ( from it as well.

Reading the above thread probably tells me what I need to know but as a access hacker I have no idea how & where one creates these scripts so that I can use them in my query?

If there's a simplier way for me to remove both fields w/o creating some external code that would be even better (and easier)
Thanks in advance for whatever tips you can give me.

- gina

 

[Remou]

How about:

Replace(Replace([short_description],"&",""),";","")

 

[gkrenton]

Hot diggity! That's not only simple but works perfectly. Thanks - never would have thought about calling it 2x. Guess I was over-thinking it.

Thanks a ton!

gina