Putting double quotes around text

[weg220]

Hello all,

I am wondering what is the easiest way to put double quotes around text in a column that is generated from a Select Query.

I tried the Format methond """"@"""" but that did not work.

Please help if you have any ideas.

thank you

Will

[jzwp11]

How about something like this that puts the double quote between two single quotes (apostrophes)

SELECT tblCourses.pkCourseID, '"' & tblCourses.txtCouseTitle & '"'
FROM tblCourses;


Or this

SELECT tblCourses.pkCourseID, chr(34) & tblCourses.txtCouseTitle & chr(34)
FROM tblCourses;

[weg220]

I was hoping not to use SQL, is there a way to add the Double quotes in the Format Property or in the query Columm?

thanks for the response

[jzwp11]

You can just use this '"' & tblCourses.txtCouseTitle & '"' or this: chr(34) & tblCourses.txtCouseTitle & chr(34) in the column; it would be essentiall a calculated field.
The SQL text is just easier to show in a post rather than the design grid.

[weg220]

Perfect you're the best, that worked Happy Holiday's

[jzwp11]

You're welcome & have a great holiday!