Hello
How can i combine these three queries??
SELECT Sum(T_MonthlyTotals2.Cash) AS [Cash Outstanding], T_MonthlyTotals.[Date of Posting From], T_MonthlyTotals.[Provider Name], T_MonthlyTotals2.[RCPT #], T_MonthlyTotals2.[Source of Payment], T_MonthlyTotals2.[Cash Cleared]
FROM T_MonthlyTotals INNER JOIN T_MonthlyTotals2 ON T_MonthlyTotals.ID = T_MonthlyTotals2.[ID Main Table]
GROUP BY T_MonthlyTotals.[Date of Posting From], T_MonthlyTotals.[Provider Name], T_MonthlyTotals2.[RCPT #], T_MonthlyTotals2.[Source of Payment], T_MonthlyTotals2.[Cash Cleared]
HAVING (((T_MonthlyTotals2.[Cash Cleared])=No));
SELECT T_MonthlyTotals2.Check AS [Check Outstanding], T_MonthlyTotals.[Date of Posting From], T_MonthlyTotals.[Date of Posting To], T_MonthlyTotals.[Provider Name], T_MonthlyTotals2.[RCPT #], T_MonthlyTotals2.[Source of Payment]
FROM T_MonthlyTotals INNER JOIN T_MonthlyTotals2 ON T_MonthlyTotals.ID = T_MonthlyTotals2.[ID Main Table]
WHERE (((T_MonthlyTotals2.[Check Cleared])=No));
SELECT T_MonthlyTotals2.[Credit Card] AS [Credit Card Outstanding], T_MonthlyTotals.[Date of Posting From], T_MonthlyTotals.[Date of Posting To], T_MonthlyTotals.[Provider Name], T_MonthlyTotals2.[RCPT #], T_MonthlyTotals2.[Source of Payment]
FROM T_MonthlyTotals INNER JOIN T_MonthlyTotals2 ON T_MonthlyTotals.ID = T_MonthlyTotals2.[ID Main Table]
GROUP BY T_MonthlyTotals2.[Credit Card], T_MonthlyTotals.[Date of Posting From], T_MonthlyTotals.[Date of Posting To], T_MonthlyTotals.[Provider Name], T_MonthlyTotals2.[RCPT #], T_MonthlyTotals2.[Source of Payment], T_MonthlyTotals2.[Credit Card Cleared]
HAVING (((T_MonthlyTotals2.[Credit Card Cleared])=No));
Thank you