Visual Basic - Error consulta SQL ayudaaaaa!!!

Hola tengo una consulta sql (la muestro mas abajo) que al ejecutarla desde visual me tira un error cerca de la palabra INNER, el problema es que la misma consulta la ejecuto en Access o SQL Server y funciona..... tengo consultas muchisimo mas largas que funcionan bien... por favor ayudenme no logro detecar el error... les dejo la consulta.

rs.Open "SELECT SHIPPER_LINE.TRANSACTION_ID, INVENTORY_TRANS.PART_ID, PART.DESCRIPTION," & _
"SHIPPER_LINE.CUST_ORDER_ID, SHIPPER_LINE.PACKLIST_ID, INVENTORY_TRANS.TRANSACTION_DATE," & _
"SHIPPER_LINE.LINE_NO, SHIPPER_LINE.SHIPPED_QTY, SHIPPER_LINE.UNIT_PRICE, CUSTOMER_ORDER.CUSTOMER_ID" & _
"FROM (PART INNER JOIN (SHIPPER_LINE INNER JOIN INVENTORY_TRANS ON SHIPPER_LINE.TRANSACTION_ID = INVENTORY_TRANS.TRANSACTION_ID) ON PART.ID = INVENTORY_TRANS.PART_ID) INNER JOIN CUSTOMER_ORDER ON SHIPPER_LINE.CUST_ORDER_ID = CUSTOMER_ORDER.ID" & _
"where (((INVENTORY_TRANS.TRANSACTION_DATE) Between '" & DTPicker1.Value & "' And '" & DTPicker2.Value & "') AND ((SHIPPER_LINE.SHIPPED_QTY)>=0))" & _ "order by INVENTORY_TRANS.TRANSACTION_DATE", conexion, adOpenDynamic, adLockOptimistic

Muchas Gracias!!!!!

Pablo.

SHIPPER_LINE.CUST_ORDER_ID = CUSTOMER_ORDER.ID" & _
"where (((INVENTORY_TRANS.TRANSACTION_DATE) Between '" &

]Esta linea le falta un espacio

SHIPPER_LINE.CUST_ORDER_ID = CUSTOMER_ORDER.ID " & _
"where (((INVENTORY_TRANS.TRANSACTION_DATE) Between '" &

el visual lo interpreta asi

CUSTOMER_ORDER.IDwhere

Eso no existe en el sql

Y hay mas lineas asi, checa el query antes de ejecutarlo, como lo trae el mismo visual.