How to eliminate a double quote

[Jacob Mathai]

I have a string with one or more double quotes in it. How can I remove the double quotes? (I was able to remove single quotes.)

Example: Purchase "other items". (This the data in a column.)

I want to change it to Purchase other items

 

[RuralGuy]

Replace([YourField],Chr(34),"")

 

[Jacob Mathai]

Thanks Rural Guy. It worked.

 

[RuralGuy]

Glad I could help.