Reshmi mohankumar
Registered User.
- Local time
- Today, 18:46
- Joined
- Dec 5, 2017
- Messages
- 101
i am getting parameter pop outs for below query!, will any body find out where it occurs?
SELECT DISTINCTROW Sum(Nz([SumOfPURE])) AS RCPT_PURE, Sum(Nz([SumOfMC])) AS RCPTMC, Sum(Nz([SumOfST_AMT])) AS RCPTST_AMT, Sum(Nz([SumOfPAYPURE])) AS PAY_PURE, Sum(Nz([SumOfMC_AMT])) AS PAYMC_AMT, Sum(Nz([SumOfPAYST_AMT])) AS PAYST_AMT, SMITH.SMITH, [RCPT_PURE]-[PAY_PURE] AS [PURE BAL], [RCPTMC]-[PAYMC_AMT] AS [MC BAL], [RCPTST_AMT]-[PAYST_AMT] AS [ST AMT BAL]
FROM (SMITH LEFT JOIN QRY_PAY_PURE_MC_sum_ledger ON SMITH.[SMITH] = QRY_PAY_PURE_MC_sum_ledger.[SMITH]) LEFT JOIN QRY_RCPT_PURE_MC_sum_ledger ON SMITH.[SMITH] = QRY_RCPT_PURE_MC_sum_ledger.[SMITH]
GROUP BY SMITH.SMITH, [RCPT_PURE]-[PAY_PURE], [RCPTMC]-[PAYMC_AMT], [RCPTST_AMT]-[PAYST_AMT], QRY_RCPT_PURE_MC_sum_ledger.SMITH, QRY_PAY_PURE_MC_sum_ledger.SMITH;
SELECT DISTINCTROW Sum(Nz([SumOfPURE])) AS RCPT_PURE, Sum(Nz([SumOfMC])) AS RCPTMC, Sum(Nz([SumOfST_AMT])) AS RCPTST_AMT, Sum(Nz([SumOfPAYPURE])) AS PAY_PURE, Sum(Nz([SumOfMC_AMT])) AS PAYMC_AMT, Sum(Nz([SumOfPAYST_AMT])) AS PAYST_AMT, SMITH.SMITH, [RCPT_PURE]-[PAY_PURE] AS [PURE BAL], [RCPTMC]-[PAYMC_AMT] AS [MC BAL], [RCPTST_AMT]-[PAYST_AMT] AS [ST AMT BAL]
FROM (SMITH LEFT JOIN QRY_PAY_PURE_MC_sum_ledger ON SMITH.[SMITH] = QRY_PAY_PURE_MC_sum_ledger.[SMITH]) LEFT JOIN QRY_RCPT_PURE_MC_sum_ledger ON SMITH.[SMITH] = QRY_RCPT_PURE_MC_sum_ledger.[SMITH]
GROUP BY SMITH.SMITH, [RCPT_PURE]-[PAY_PURE], [RCPTMC]-[PAYMC_AMT], [RCPTST_AMT]-[PAYST_AMT], QRY_RCPT_PURE_MC_sum_ledger.SMITH, QRY_PAY_PURE_MC_sum_ledger.SMITH;