在Access里寫了一個用于收發存匯總表的帶引數查詢 InvSection 如下。需要兩個引數a & b
查詢執行沒有什么問題。
PARAMETERS a DateTime, b DateTime;
SELECT QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, IIf([FlowDate]<[a],"期初數",IIf([EstQty]>0,"期間入數","期間出數")) AS 列標, Sum(QryInvFlow.EstQty) AS 值
FROM QryInvFlow
WHERE (((QryInvFlow.FlowDate)<=[b]))
GROUP BY QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, IIf([FlowDate]<[a],"期初數",IIf([EstQty]>0,"期間入數","期間出數"));
UNION All
SELECT QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, "期末數" AS 列標, Sum(QryInvFlow.EstQty) AS 值
FROM QryInvFlow
WHERE (((QryInvFlow.FlowDate)<=[b]))
GROUP BY QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, "期末數";
UNION ALL
SELECT QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, IIf([FlowDate]<[a],"期初金額",IIf([EstCostCal]>0,"期間入金額","期間出金額")) AS 列標, Sum(QryInvFlow.EstCostCal) AS 值
FROM QryInvFlow
WHERE (((QryInvFlow.FlowDate)<=[b]))
GROUP BY QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, IIf([FlowDate]<[a],"期初金額",IIf([EstCostCal]>0,"期間入金額","期間出金額"));
UNION ALL SELECT QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, "期末金額" AS 列標, Sum(QryInvFlow.EstCostCal) AS 值
FROM QryInvFlow
WHERE (((QryInvFlow.FlowDate)<=[b]))
GROUP BY QryInvFlow.ProdMesu, QryInvFlow.ProdMCate, QryInvFlow.ProdCate, "期末金額";
現在希望在某報表中使用這個查詢作為資料源，并傳參。
Me.RecordSource=？
網上到處都沒有搜到帶引數 RecordSource的寫法。請大神們幫看看。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/81787.html
標籤：Access
上一篇：VMware虛擬機的安裝