SELECT DWQRYDATA_SLSDSI.STORE_ID, DWDATA_KSSCAT.CATDESC, Sum(DWQRYDATA_SLSDSI.TOTAL_SALES) AS SumOfTOTAL_SALES, Sum(DWQRYDATA_SLSDSI.TOTAL_SALES_AT_COST) AS SumOfTOTAL_SALES_AT_COST, Sum(DWQRYDATA_SLSDSI.TOTAL_UNITS) AS SumOfTOTAL_UNITS, Year([DATE_ID]) AS [Year]
FROM (DWDATA_KSSPRODUCT INNER JOIN DWQRYDATA_SLSDSI ON (DWDATA_KSSPRODUCT.ITEM = DWQRYDATA_SLSDSI.ITEM) AND (DWDATA_KSSPRODUCT.LINE = DWQRYDATA_SLSDSI.LINE)) INNER JOIN DWDATA_KSSCAT ON (DWDATA_KSSPRODUCT.SUBCATNUM = DWDATA_KSSCAT.SUBCATNUM) AND (DWDATA_KSSPRODUCT.CATNUM = DWDATA_KSSCAT.CATNUM) AND (DWDATA_KSSPRODUCT.DEPTNUM = DWDATA_KSSCAT.DEPTNUM)
GROUP BY DWQRYDATA_SLSDSI.STORE_ID, DWDATA_KSSCAT.CATDESC, Year([DATE_ID]), DWQRYDATA_SLSDSI.DATE_ID
HAVING (((Sum(DWQRYDATA_SLSDSI.TOTAL_SALES))>0) AND ((DWQRYDATA_SLSDSI.DATE_ID) Between DateAdd("yyyy",-1,DateSerial(Year(Date()),1,1)) And DateAdd("yyyy",-1,Date()-2) Or (DWQRYDATA_SLSDSI.DATE_ID) Between DateSerial(Year(Date()),1,1) And Date()-2));