Evaluate a RecordSource Access 2010 statements with parameter query examples-CodePudding

In the Access wrote one for the query InvSection transceiver deposit summary table with parameters as follows, need two parameters a & amp; B
There's nothing wrong with the query execution,

The PARAMETERS a DateTime, b DateTime;
The SELECT QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, IIf ([FlowDate] <[a], "ending", the IIf ([EstQty] & gt; 0, "during the number", "during which") AS the column, the Sum (QryInvFlow. EstQty) AS value
The FROM QryInvFlow
The WHERE (((QryInvFlow FlowDate) & lt;=[b]))
GROUP BY QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, IIf ([FlowDate] <[a], "ending", the IIf ([EstQty] & gt; During a 0, "into the number", "during which"));

UNION All

SELECT QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, "the final number" AS standard, the Sum (QryInvFlow. EstQty) AS value
The FROM QryInvFlow
The WHERE (((QryInvFlow FlowDate) & lt;=[b]))
GROUP BY QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, "the final number";

UNION ALL

The SELECT QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, IIf ([FlowDate] <[a], "initial value", the IIf ([EstCostCal] & gt; 0, "into the amount during the", "during the amount")) AS the column, the Sum (QryInvFlow. EstCostCal) AS value
The FROM QryInvFlow
The WHERE (((QryInvFlow FlowDate) & lt;=[b]))
GROUP BY QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, IIf ([FlowDate] <[a], "initial value", the IIf ([EstCostCal] & gt; 0, "into the amount during the", "during the amount"));

UNION ALL SELECT QryInvFlow ProdMesu, QryInvFlow. ProdMCate, QryInvFlow. ProdCate, "the final amount" AS standard, the Sum (QryInvFlow. EstCostCal) AS value
The FROM QryInvFlow
The WHERE (((QryInvFlow FlowDate) & lt;=[b]))
GROUP BY QryInvFlow ProdMesu, QryInvFlow ProdMCate, QryInvFlow. ProdCate, "the final amount";

I would now like to use this query in a statement as a data source, and preach,
Me. RecordSource=?
Online search everywhere with the parameter RecordSource method and the great god, please help have a look,