Combining two queries.

[Ray67]

How can i combine these two queries???

SELECT T_DocInfo.[Provider Name], [T_Fee Settlement Balance].Month, [T_Fee Settlement Balance].Year, [T_Fee Settlement Balance].[Fee Settlement Balance], [T_Fee Settlement Balance].Refunds, [T_Fee Settlement Balance].[Medical Assoc Transfer], [T_Fee Settlement Balance].[Returned Checks], [T_Fee Settlement Balance].CreditsNotRecordedinClimacsCT, Sum([Fee Settlement Balance]+[Refunds]+[Medical Assoc Transfer]+[Returned Checks]-[CreditsNotRecordedinClimacsCT]) AS [Fee Settlement Sum]
FROM [T_Fee Settlement Balance] LEFT JOIN T_DocInfo ON [T_Fee Settlement Balance].[Provider Name] = T_DocInfo.ID
GROUP BY T_DocInfo.[Provider Name], [T_Fee Settlement Balance].Month, [T_Fee Settlement Balance].Year, [T_Fee Settlement Balance].[Fee Settlement Balance], [T_Fee Settlement Balance].Refunds, [T_Fee Settlement Balance].[Medical Assoc Transfer], [T_Fee Settlement Balance].[Returned Checks], [T_Fee Settlement Balance].CreditsNotRecordedinClimacsCT;

SELECT T_DocInfo.[Provider Name], Format([Date of Posting From],"mmmm") AS [Month], Format([Date of Posting From],"yyyy") AS [Year], Sum([Cash]+[Check]+[Credit Card]) AS Total


FROM (T_MonthlyTotals INNER JOIN T_MonthlyTotals2 ON T_MonthlyTotals.ID = T_MonthlyTotals2.[ID Main Table]) LEFT JOIN T_DocInfo ON T_MonthlyTotals.[Provider Name] = T_DocInfo.ID
GROUP BY T_DocInfo.[Provider Name], Format([Date of Posting From],"mmmm"), Format([Date of Posting From],"yyyy"), T_MonthlyTotals2.[Reflected last Month]
HAVING (((T_MonthlyTotals2.[Reflected last Month])=Yes));

Thank you

[RayMilhon]

Depends on how you want to join them. You can use a union query that will return all records in both queries however the Select clauses in both must A. Contain the same number of fields and b they must be the same type for Example:

Select Month(datefield), Sum(Sales) As Total Sales, "Sales" as type
From atable
Union All
Select Month(datefield, Sum(projectedSales), "Projected" 
From btable

A bit simplistic I know but the principle is the same regardless of how many tables and joins there are in the query.

Secondly If theres a link between query 1 and query 2 just put all of the fields from both in the select and make the appropriate joins in the from. If there is no link combining the 2 queries will give you a cartesian product which means if Query A Returns 10 Records and Query B returns 10 Records the combined query will return 100 Records.