SELECT TOP 3 Stock.Week AS Weeks
FROM Stock
GROUP BY Stock.Week
ORDER BY Stock.Week DESC;

SELECT WkPgQuery.ProductGroup, WkPgQuery.Weeek, IIF(IsNull(SUM(ValueQuery.ResultValue)),0,SUM(ValueQuery.ResultValue)) AS ResultValue
FROM (SELECT PGQuery.ProductGroup, WkQuery2.Weeek
FROM(SELECT S.[Product group] AS ProductGroup FROM Stock AS S GROUP BY S.[Product group]) AS PGQuery, 
(SELECT TOP 3 Stock.Weeek AS Weeek FROM Stock GROUP BY Stock.Weeek ORDER BY Stock.Weeek DESC) AS WkQuery2)  AS WkPgQuery LEFT JOIN (SELECT ValueQueryInner.ProductGroup, ValueQueryInner.Weeek, ValueQueryInner.StockDaysRangeShort, ValueQueryInner.EntityCode, ValueQueryInner.ResultValue
FROM (SELECT Stock.[Product group] AS ProductGroup, Stock.Weeek, Stock.StockDaysRangeShort, Stock.[Entity code] AS EntityCode, SUM(Stock.ResultValue) AS ResultValue
FROM Stock WHERE (Stock.StockDaysRangeShort IN (SELECT SAM_Age_Selection.Age AS Age FROM SAM_Age_Selection) AND Stock.[Entity code] IN (SELECT SAM_Entities_Selection.[Entity code] AS TargetEntity FROM SAM_Entities_Selection))
GROUP BY Stock.[Product group], Stock.Weeek, Stock.StockDaysRangeShort, Stock.[Entity code]) AS ValueQueryInner)  AS ValueQuery ON (ValueQuery.ProductGroup = WkPgQuery.ProductGroup) AND (ValueQuery.Weeek = WkPgQuery.Weeek)
GROUP BY WkPgQuery.ProductGroup, WkPgQuery.Weeek;