Quotation mark syntax

[benkingery]

I have a field that I need to perform and update statement to. I need to replace any instance of quotation marks (") with double quotation marks (""). For this I know I need the replace function, but I'm not clear on the quotation mark portion of the syntax.

Here's what I have:

Replace([EB_Description],"'"'","'""'")

Any thoughts?

 

[boblarson]

You could use

Replace([EB_Description], Chr(34), Chr(34) & Chr(34))

 

[benkingery]

You did it! Thanks.