Easy VB question

[szymek_d]

Just quick and i think easy question
I'm building a query in VB:

strSQL = "SELECT f1, f2 & ", " & f3 as fullName" & _
" from t1"

so my problem is the quotetion marks around the comma between f2 and f3. So is there a way in VB to make VB treat only those quations around the comma as character?
Sorry about poor title but i had no idea how to refer to this issue.

Thank you!!

 

[WayneRyan]

sz,

Change:

strSQL = "SELECT f1, f2 & ", " & f3 as fullName" & _
" from t1"

To:

strSQL = "SELECT f1, f2, f3 as fullName from t1"

Wayne

 

[szymek_d]

Thanks for the prompt reply

The only thing is I do want the comma to be in there, because later report gets generated based on that query and in this case I want to have comma between the first name and last name.

Is it even possible to keep that comma in there?

 

[WayneRyan]

sz,

strSQL = "SELECT f1, f2 & ', ' & f3 as fullName from t1"

Note: VBA uses the " as delimiter, SQL uses '.

Wayne

 

[szymek_d]

Thank you very much Wayne!!!

It works now.

I was using " as delimiter in SQL. It works, but it started causing problems when i started generating quereis in VBA.