Code:
SELECT Outlook_all_data.Market_Center, Outlook_all_data.[Rep Name], Outlook_all_data.Agency, Sum(IIf([Outlook_all_data].[OL Month]='JAN',[Outlook_all_data].[Revenue],0)) AS JAN, Sum(IIf([Outlook_all_data].[OL Month]='FEB',[Outlook_all_data].[Revenue],0)) AS FEB, Sum(IIf([Outlook_all_data].[OL Month]='MAR',[Outlook_all_data].[Revenue],0)) AS MAR, Sum(IIf([Outlook_all_data].[OL Month]='APR',[Outlook_all_data].[Revenue],0)) AS APR, Sum(IIf([Outlook_all_data].[OL Month]='MAY',[Outlook_all_data].[Revenue],0)) AS MAY, Sum(IIf([Outlook_all_data].[OL Month]='JUN',[Outlook_all_data].[Revenue],0)) AS JUN, Sum(IIf([Outlook_all_data].[OL Month]='JUL',[Outlook_all_data].[Revenue],0)) AS JUL, Sum(IIf([Outlook_all_data].[OL Month]='AUG',[Outlook_all_data].[Revenue],0)) AS AUG, Sum(IIf([Outlook_all_data].[OL Month]='SEP',[Outlook_all_data].[Revenue],0)) AS SEP, Sum(IIf([Outlook_all_data].[OL Month]='OCT',[Outlook_all_data].[Revenue],0)) AS OCT, Sum(IIf([Outlook_all_data].[OL Month]='NOV',[Outlook_all_data].[Revenue],0)) AS NOV, Sum(IIf([Outlook_all_data].[OL Month]='DEC',[Outlook_all_data].[Revenue],0)) AS [DEC], Sum([Outlook_all_data].[Revenue])+0 AS Total
FROM Outlook_all_data
GROUP BY Outlook_all_data.Market_Center, Outlook_all_data.[Rep Name], Outlook_all_data.Agency;
UNION ALL
SELECT "" AS Market_Center, "" AS [Rep Name], "" AS Agency, Sum(Outlook_Summary.JAN) AS SumOfJAN, Sum(Outlook_Summary.FEB) AS SumOfFEB, Sum(Outlook_Summary.MAR) AS SumOfMAR, Sum(Outlook_Summary.APR) AS SumOfAPR, Sum(Outlook_Summary.MAY) AS SumOfMAY, Sum(Outlook_Summary.JUN) AS SumOfJUN, Sum(Outlook_Summary.JUL) AS SumOfJUL, Sum(Outlook_Summary.AUG) AS SumOfAUG, Sum(Outlook_Summary.SEP) AS SumOfSEP, Sum(Outlook_Summary.Oct) AS SumOfOCT, Sum(Outlook_Summary.NOV) AS SumOfNOV, Sum(Outlook_Summary.DEC) AS SumOfDEC, Sum(Outlook_Summary.Total) AS SumOfTotal
FROM Outlook_Summary
GROUP BY "", "", "";