Почти идентичные запросы но разные результаты

SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '01.04-07.04')) 
GROUP BY Distrib_corr.[Code TO transfered]
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '08.04-14.04')) 
GROUP BY Distrib_corr.[Code TO transfered]
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '15.04-21.04')) 
GROUP BY Distrib_corr.[Code TO transfered]
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '22.04-30.04')) 
GROUP BY Distrib_corr.[Code TO transfered]

SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM, DATABASE.Period
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '01.04-07.04')) 
GROUP BY Distrib_corr.[Code TO transfered], DATABASE.Period
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM, DATABASE.Period
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '08.04-14.04')) 
GROUP BY Distrib_corr.[Code TO transfered], DATABASE.Period
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM, DATABASE.Period
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '15.04-21.04')) 
GROUP BY Distrib_corr.[Code TO transfered], DATABASE.Period
UNION
SELECT Distrib_corr.[Code TO transfered], SUM(DATABASE.Sales) AS SActPM, DATABASE.Period
FROM Distrib_corr INNER JOIN [DATABASE] ON (Distrib_corr.City = DATABASE.City) AND (Distrib_corr.Name = DATABASE.Distribution) 
WHERE (((DATABASE.Type) = 'Actual') AND ((DATABASE.Year) = 2013) AND ((DATABASE.Month) = 4) AND ((DATABASE.[TYPE Delivery]) = 'Sell-in') AND ((DATABASE.Brand) = 'Kauffman') AND ((DATABASE.Period)= '22.04-30.04')) 
GROUP BY Distrib_corr.[Code TO transfered], DATABASE.Period