I am trying to replace a query that refers to another query, to be done within the same query.
the original query is
qry0BankDeposits_Summary.SumOfDepositTotal AS TotalDeposits,
LEFT JOIN qry0BankDeposits_Summary ON tblControlTicket.ControlTicketNum = qry0BankDeposits_Summary.ControlTNum)
now the code for query "qry0BankDeposits_Summary"
is as follows
SELECT tblPOS_BankDeposits.ControlTNum, Sum(tblPOS_BankDeposits.DepositTotal) AS SumOfDepositTotal
GROUP BY tblPOS_BankDeposits.ControlTNum
can somebody help to create a query that incorporates both of them?