I am using Get External Data under Data in Excel, From Access, then choosing the Query.
Code:
SELECT [Transaction Level Detail with Calc Columns Added].[Fiscal Month], tblDate.CalendarMonth, [Transaction Level Detail with Calc Columns Added].[Profit Center Code], [Transaction Level Detail with Calc Columns Added].[Customer Name], [Transaction Level Detail with Calc Columns Added].[Ship To City], [Transaction Level Detail with Calc Columns Added].[Product Number], [Transaction Level Detail with Calc Columns Added].[Base Product Number], Sum([Transaction Level Detail with Calc Columns Added].[Net Invoiced Amount at AFX]) AS [SumOfNet Invoiced Amount at AFX], Sum([Transaction Level Detail with Calc Columns Added].[Net Quantity in GAL]) AS [SumOfNet Quantity in GAL]FROM tblDate INNER JOIN [Transaction Level Detail with Calc Columns Added] ON tblDate.DayOfTheMonth = [Transaction Level Detail with Calc Columns Added].[Invoiced Date]
GROUP BY [Transaction Level Detail with Calc Columns Added].[Fiscal Month], tblDate.CalendarMonth, [Transaction Level Detail with Calc Columns Added].[Profit Center Code], [Transaction Level Detail with Calc Columns Added].[Customer Name], [Transaction Level Detail with Calc Columns Added].[Ship To City], [Transaction Level Detail with Calc Columns Added].[Product Number], [Transaction Level Detail with Calc Columns Added].[Base Product Number], [Transaction Level Detail with Calc Columns Added].[Fiscal Year]
HAVING ((([Transaction Level Detail with Calc Columns Added].[Profit Center Code])="3359" Or ([Transaction Level Detail with Calc Columns Added].[Profit Center Code])="3780" Or ([Transaction Level Detail with Calc Columns Added].[Profit Center Code])="3730") AND (([Transaction Level Detail with Calc Columns Added].[Product Number]) Not Like "9699*") AND (([Transaction Level Detail with Calc Columns Added].[Fiscal Year])>2013));