Do just one query and group it by year:SELECT [DL].[Customer] , YEAR([DL].[Date Received]) AS [Year] , COUNT([DL].[Date Received]) AS [CountOfDate Received1]FROM [DL]GROUP BY [DL].[Customer] , YEAR([DL].[Date Received]);
If you then want to get it in a pivoted form, use the pivot operator like shown below:SELECT * FROM ( SELECT [DL].[Customer] , YEAR([DL].[Date Received]) AS [Year] , COUNT([DL].[Date Received]) AS [CountOfDate Received1]FROM [DL]GROUP BY [DL].[Customer] , YEAR([DL].[Date Received])) sPIVOT (SUM([CountOfDate Received1]) FOR [Year] IN ([2011],[2012],[2013]))P