Replace Quotation Marks

[samMSaccess31]

Hello everyone,

So I am trying to use a query to replace quotation marks in EVERY column in a table. Now, I have two problems here...


1.) I think I am looking at replacing each column individually. For example, for a table with 4 columns, I am looking at...
Replace(

![Column1], etcetc), then
Replace(

![Column2], etcetc), then
Replace(

![Column3], etcetc), then
Replace(

![Column4], etcetc)

This is NOT a big deal to me (Problem 2 is the bigger problem!) I was just wondering if I was missing something obvious and creating more work for myself...



2.) As everyone knows the Replace functions works as such so that:
Replace("alphabet", "bet", "hydro") would return "alphahydro". You are supposed to surround the 2nd function (find) and third function (replacement) with quotation marks.

However, I am trying to replace the quotation marks in the table!! And in the 2nd function (find), I am surrounding the quotation mark symbol with quotation marks (so it looks like """) and it is not working!

If anybody could help me out with this that would be great. Also, if somebody is confused by my explanation and needs a little clarification PLEASE let me know so I can explain it a little better. Thanks

Sam

 

[bob fitz]

Instead of 3 double quotes(""") try a single double single('"')

 

[samMSaccess31]

No Bob, that isn't working for me. Does anybody else have any ideas?

 

[bob fitz]

Can you show us the sql of the query.

 

[MSAccessRookie]

I believe that Chr(34) will provide a Quote character that you are loooking for.

 

[vbaInet]

, I am trying to replace the quotation marks in the table!! And in the 2nd function (find), I am surrounding the quotation mark symbol with quotation marks (so it looks like """) and it is not working!

I know MSAccessRookie has given you the answer but I just thought I should let you know why yours was failing. You needed four quotes, not three.

Replace("""", """", "")

Reads, replace on double quote (") with nothing ().