I have the folloing sql CODE BUT THE DOUBLE QUOTES ARE GIVING ME A PROBLEM when rewrite into VBA
Sql is: SELECT F1 &"x" & F2 FROM XTABLE WILL GIVE ME A RESULT OF F1xF2
Rewrite it into VBA format as :
DIM mySQL1 as STRING
mySQL1 = "select f1 &"x"& f2 from xtable"
I get compile error on the select statement because of the double quotes.
QUESTION: how do i compose the sql statement into a VBA acceptable format and getting the same result??