Double Quotation Marks holding a Double Quotation Mark? How To?

[JonoGee]

Hi Folks. Good evening. Its been a while. I have been developing my skills through lots of practice.


However, I have just stumbled across a little problem I can seem to figure out or find the right words in a search to find the right result.

I want to use an expresison in a query to return a string that is in double quotation marks..
Wanted Result.... "SampleFieldData = SampleFieldData2"; including the quotation marks and semi colon at the end

So i have tried.... Wanted Result: """ & [SampleFieldData] & "=" & [SampleFieldData2] & "";"

Nothing I try seems to enjoy 3 Double exclamation marks being used..

Any ideas please folks..?

[Minty]

Sometimes you can use Chr(34) instead of the quote or single quotes:

Result = Chr(34) & "[SampleField1] = SampleField2 " & Chr(34) & ";"

[JonoGee]

Thanks for the quick reply....
I have given it a go but I am getting the following results..... "[CustomFieldName] = [CustomFieldValue] ";

I used this in the query..... CustomFieldLine: Chr(34) & "[CustomFieldName] = [CustomFieldValue] " & Chr(34) & ";"

Have i done something wrong you can see? The fields [CustomFieldName] & [CustomFieldValue] are fields in the query

[davegri]

Result: Chr(34) & [column1] & " = " & [column2] & Chr(34) & ";"

[JonoGee]

Thank you very much Dave. Worked a treat!!

[davegri]

Thank you very much Dave. Worked a treat!!

Glad to help. In general, if you want double quotes to show as part of the string, rather than to act as delimeters, you can use chr(34). Also, chr(39) is a single quote.

[Minty]

I read it too literally. Doh!
Glad Dave sorted it out.

[davegri]

I read it too literally. Doh!
Glad Dave sorted it out.

It was a bit confusing whether the OP wanted to show the variables or the variable values. All's well that ends well.