fieldset{padding:10px;}
请问vba可以调用视图吗？我用的VBA写的strsql=”SELECTW.cWhCodeas仓库号,W.cWhNameas仓库名称,I.cInvCodeas存货编码,I.cInvNameas存货名称,I.cInvCCodeas存货大类编码,IC.cInvCNameas存货大类名称,”_&”(fInQuantity)AS现存量,(fTransInQuantity)AS调拔待入数量,(ISNULL(fInQuantity,0)+ISNULL(fTransInQuantity,0))AS到货在检,”_&”(fOutQuantity)AS待发货量,(fTransOutQuantity)AS调拔待发数量,(ISNULL(fOutQuantity,0)+ISNULL(fTransOutQuantity,0))AS预计出库数量,”_&”(CASEWHENbInvBatch=1THENCASEWHENbStopFlag=1ORbGSPStop=1THEN0ELSEISNULL(iQuantity,0)-IsNull(fStopQuantity,0)END+ISNULL(fInQuantity,0)+ISNULL(fTransInQuantity,0)-ISNULL(fOutQuantity,0)-“_&”ISNULL(fTransOutQuantity,0)ELSECASEWHENbStopFlag=1ORbGSPStop=1THEN0ELSEISNULL(iQuantity,0)-IsNull(fStopQuantity,0)ENDEND)AS可用量”_&”FROMv_ST_currentstockForReportCSinnerjoindbo.InventoryIONI.cInvCode=CS.cInvCode”_&”leftjoindbo.InventoryClassICONIC.cInvCCode=I.cInvCCodeLEFTOUTERJOINdbo.ComputationUnitCU_GON”_&”I.cSTComUnitCode=CU_G.cComUnitCodeLEFTOUTERJOINdbo.ComputationUnitCU_AONI.cAssComUnitCode=CU_A.cComunitCode”_&”LEFTOUTERJOINdbo.ComputationUnitCU_MONI.cComUnitCode=CU_M.cComunitCodeLEFTOUTERJOINdbo.WarehouseWONCS.cWhCode=W.cWhCode”_&”leftjoinvendorv1onv1.cvencode=cs.cvmivencodeleftjoinv_aa_enumE1onE1.enumcode=ISNULL(cs.iExpiratDateCalcu,0)andE1.enumtype=N’SCM.ExpiratDateCalcu'”_&”LEFTOUTERJOINdbo.v_aa_enumEwith(nolock)onE.enumcode=convert(nchar,CS.cMassUnit)andE.enumType=N’ST.MassUnit'”提示v_ST_currentstockForReport附近有错误，可我就是看不出来。是不是不可以引用视图啊？
vba ——解决方案——————————————————–FROM前面缺少空格你看报表时，梅里雪山的金丝猴刚好爬上树尖。