[AccessD] Is there a way to force Access to place single quotes on generated SQL

[Brad Marks]

All,

I have a number of Access queries that I need to port to ColdFusion.

When Access generates SQL from "Design View", it uses double quotes such as  

WHERE JOBS.JOBNO="SO80427";

I would like Access to generate this line with single quotes - like this.

WHERE JOBS.JOBNO='SO80427';

Is there a setting someplace in Access to make this happen.

Thanks,

Brad