Concatinate Quotes (XP)

[tdelucia]

I would like to concatinate double quotes onto the ends of a description field, I am using an update query to concatinate all other characters or text, but I cannot figure out how to do quotes. Access does not like, " " " & [field1] & " " ", and I can see why, but how to fix?

[MarkJ]

I can't remember if this works in a Query, but you can use the Character Code for quotes in the coding environment. Try it in the Query to see if it works. A double quote is Chr(34). So your string would be: Chr(34) & [field1] & Chr(34)

You can also use two doube-quotes instead of the Chr(34) in many cases: "" & [field1] & ""

Hope this helps

[Douglas Martin]

To get a single double quote as a string, use four double quotes """". The outer two delimit the string, the inner two become the double-quote character (as opposed to the string delimiter).

[tdelucia]

Sorry for the lag in response, this worked great! Thanks!