SELECT [xRef - Account List for Cash Flow Daily].ProdType, [xRef - Account List for Cash Flow Daily].Type, [xRef - Account List for Cash Flow Daily].RF, [xRef - Account List for Cash Flow Daily].Description, Sum(tbl_Cash_Flow_Daily.DP) AS SumOfDP, Sum(tbl_Cash_Flow_Daily.EP) AS SumOfEP, Sum([DP]+[EP]) AS [Gross Purchases], Sum(tbl_Cash_Flow_Daily.DR) AS SumOfDR, Sum(tbl_Cash_Flow_Daily.ER) AS SumOfER, Sum([DR]+[ER]) AS [Gross Redemptions], Sum([DP]+[EP]+[DR]+[ER]) AS NetCashFlow, IIf([MoneyMktAdj] Is Null,0,[MoneyMktAdj]) AS [Money Market Adj], Sum(tbl_Cash_Flow_Daily.[GL Activity]) AS [SumOfGL Activity], Sum(([DP]+[DR])) AS NetDirect, Sum(([EP]+[ER])) AS NetExchange, [Forms]![Cash Flow]![Start Date] AS StartDate, [Forms]![Cash Flow]![End Date] AS EndDate, [xRef - Account List for Cash Flow Daily].Sort INTO tbl_CashFlow_Daily_by_Fund
FROM ([xRef - Account List for Cash Flow Daily] INNER JOIN tbl_Cash_Flow_Daily ON [xRef - Account List for Cash Flow Daily].RF = tbl_Cash_Flow_Daily.MfactShortDescription) LEFT JOIN qry_CashFlow_MMAdj_step2 ON tbl_Cash_Flow_Daily.MfactShortDescription = qry_CashFlow_MMAdj_step2.RF
GROUP BY [xRef - Account List for Cash Flow Daily].ProdType, [xRef - Account List for Cash Flow Daily].Type, [xRef - Account List for Cash Flow Daily].RF, [xRef - Account List for Cash Flow Daily].Description, IIf([MoneyMktAdj] Is Null,0,[MoneyMktAdj]), [Forms]![Cash Flow]![Start Date], [Forms]![Cash Flow]![End Date], [xRef - Account List for Cash Flow Daily].Sort
ORDER BY [xRef - Account List for Cash Flow Daily].RF;