vba SQL question

[Palmyra]

I have the following SQL in some vba. I can't seem to figure out the syntax to get the right parenthesis for the subquery. Cany ideas?

strsql = "SELECT wall.wclient " & _
"FROM wall " & _
"INNER JOIN client " & _
"ON wall.wclient = client.clnum " & _
"WHERE wall.wpartype = 'c' and clnum IN " & _
"(SELECT LEFT(fmatter,5) FROM folder
WHERE fbarcode = " & " '" & glsFolder & "'"

Thanks.

 

[markros]

strsql = "SELECT wall.wclient " & _
"FROM wall " & _
"INNER JOIN client " & _
"ON wall.wclient = client.clnum " & _
"WHERE wall.wpartype = 'c' and clnum IN " & _
"(SELECT LEFT(fmatter,5) FROM folder
WHERE fbarcode = " & " '" & glsFolder & "')"

 

[simian101]

add

debug.print strsql

and you will probably see the problem...

Right off hand I see you are missing a ")" at the end.

Simi