Here is the code I am using for combining report

[Kat21]

SELECT DISTINCTROW Customer.CustType, Sum([Combined Sales By Customer].UnitsMTD) AS [Sum Of UnitsMTD], Sum([Combined Sales By Customer].SalesMTD) AS [Sum Of SalesMTD], Sum([Combined Sales By Customer].CostMTD) AS [Sum Of CostMTD], Sum([Combined Sales By Customer].SalesPYTD) AS [Sum Of SalesPYTD], Sum([Combined Sales By Customer].CostPYTD) AS [Sum Of CostPYTD], Sum([Combined Sales By Customer].SalesYTD) AS [Sum Of SalesYTD], Sum([Combined Sales By Customer].CostYTD) AS [Sum Of CostYTD]
FROM Customer, [Combined Sales By Customer]
GROUP BY Customer.CustType;