How do I display ASCII Characters in an Access Query

[Dave]

I have a query running that displays information to our organziation. I
want to encles a field record with a " Quotation mark.

This is an example of where I am:

Exp: "Hello everyone in " & [DistDB]![Dist] & ". How are you?"

Just an example. I want to enclose the [DistDB]![Dist] in quotation marks.

How do I get there from here?

Thanks

Dave

 

[John Spencer]

Try

Exp: "Hello everyone in """ & [DistDB]![Dist] & """. How are you?"

OR

Exp: "Hello everyone in " & Chr(34) & [DistDB]![Dist] & Chr(34) & ". How
are you?"

If you want to embed quotation marks inside a string, you use two quotation
marks in a row or you can use the Chr(n) function to return a quotation
mark.