I tried to put your idea into:
StrSqlInvExt = "SELECT INVCEHED.CUSN65, INVCEHED.DTIN65, OEP845L2.TENT45, DELADDS.ONAM45, DELADDS.OAD445, TRIM(DELADDS.OAD545), OEP040L1.SVIA40, INVCEHED.INVN65, INVCEHED.CUSO65, SQP608L1.ICAT08, OEP040L1.CORD40, INVCEHED.ORDN65, min(case when INP40.TLNO40='1' then INP40.TLIN40 end) as ext_text_line_1, INVBYORD.LQTY70, INVBYORD.DGRP70, INVBYORD.DGRP70, PARTS.PGMN35, PARTS.PDES35, " _
& "INU056L1.XPIF56, INU056L1.XDIF56, INU056L1.WNET56, INP056L1.IDMD56, OEP845L2.IPNR45, INVCEHED.CURN65, INVCEHED.CURC65, INVCEHED.CURT65, min(case when INP40.TLNO40='2' then INP40.TLIN40 end) as ext_text_line_2 " _
& Chr(13) & "" & Chr(10) & _
"FROM EUROPEAN.TVSPF00.DELADDS DELADDS, EUROPEAN.TVSPF00.INP056L1 INP056L1, EUROPEAN.TVSPF00.INP40 INP40, EUROPEAN.TVSPF00.INU056L1 INU056L1, EUROPEAN.TVSPF00.INVBYORD INVBYORD, EUROPEAN.TVSPF00.INVCEHED INVCEHED, " _
& " EUROPEAN.TVSPF00.OEP040L1 OEP040L1, EUROPEAN.TVSPF00.OEP065 OEP065, EUROPEAN.TVSPF00.OEP845L2 OEP845L2, EUROPEAN.TVSPF00.PARTS PARTS, EUROPEAN.TVSPF00.SQP608L1 SQP608L1 " _
& Chr(13) & "" & Chr(10) & _
"WHERE INVCEHED.CONO65 = OEP065.CONO65 AND INVCEHED.INVN65 = OEP065.INVN65 AND INVCEHED.CONO65 = INVBYORD.CONO70 AND INVCEHED.INVN65 = INVBYORD.INVN70 AND INVBYORD.CONO70 = PARTS.CONO35 AND INVBYORD.CATN70 = PARTS.PNUM35 AND INVCEHED.CONO65 = DELADDS.CONO45 AND INVCEHED.ORDN65 = DELADDS.ORDN45 AND INVCEHED.CONO65 = INP056L1.CONO56 AND INVCEHED.ORDN65 = INP056L1.ORDN56 AND INVCEHED.DESN65 = INP056L1.DESN56 AND INVCEHED.CONO65 = INU056L1.CONO56 AND INVCEHED.ORDN65 = INU056L1.ORDN56 AND " _
& " INVCEHED.DESN65 = INU056L1.DESN56 AND INVCEHED.CONO65 = OEP845L2.CONO45 AND INVCEHED.ORDN65 = OEP845L2.ISHO45 AND (INP40.TTYP40='O') AND (INP40.USGC40='E') and INVCEHED.DESN65 = OEP845L2.IDNS45 AND INVCEHED.CONO65 = OEP040L1.CONO40 AND INVCEHED.ORDN65 = OEP040L1.ORDN40 AND OEP040L1.CONO40 = INP40.CONO40 AND OEP040L1.ORDN40 = INP40.TREF40 AND INVBYORD.CONO70 = SQP608L1.CONO08 AND INVBYORD.CATN70 = SQP608L1.PNUM08 AND " _
& " ((INVCEHED.CONO65='88') AND " _
& " (INVCEHED.INVN65 Between '" & jba_from & "' and '" & jba_to & "')) group by INVCEHED.INVN65 ORDER BY INVCEHED.INVN65 DESC" _
but there appears sql query error. what is wrong?