SQL to VBA Syntax Error

[playern07]

Hello,

I created an excel file that transforms SQL to VBA. It works great, I recently came across an error when I tried to buid a query in text format. It is pasted below. Any ideas?

"SELECT C.FACILITY_ID,C.SALES_TRANS_DT, C.CATEGORY, C.TIMEPERIOD, C.TIMECRITERIA, SUM(C.TOTALITEMQTY) " & _
"FROM ( " & _

BreadQRY = "(SELECT " & _
"STIL.FACILITY_ID, " & _
"STIL.SALES_TRANS_DT, " & _ ...

 

[tweedle]

I think we don't see enough to determine anything.
If you could also cite the error you see...

 

[playern07]

I will start a different thread due to a new found error... Mods please delete.