Select Year(MatDateOpened) as YrOpened, SUM(1) as NewFilesOpened from Matter where Year(MatDateOpened) = 2015 Group By Year(MatDateOpened) Union All select Year(MatDateOpened) as YrOpened, SUM(1) as NewFilesOpened from Matter where Year(MatDateOpened) = 2014 Group By Year(MatDateOpened)