SELECT ke.KPM, ke.DateShort AS Дата, (select k2.Errcount from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
k2.ErrorType= "Ошибочный г/р" ) AS [Ошибочный г/р], (select k2.Errcount from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
k2.ErrorType= "Не указан г/н" ) AS [Не указан г/н], (select k2.Errcount from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
k2.ErrorType= "Сокращение ФИО " ) AS [Сокращение ФИО], (select k2.Errcount from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
k2.ErrorType= "Не указан код груза" ) AS [Не указан код груза], (select k2.Errcount from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
k2.ErrorType= "Не указан г/в " ) AS [Не указан г/в], (select Sum(k2.Errcount) from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
(k2.ErrorType= "Неверный регион"  or k2.ErrorType= "Не указан регион" )) AS [Неверный или не указан регион],
(select Sum( k2.Errcount) from kpm_errors as k2 where 
k2.dateshort=ke.dateshort and k2.kpm=ke.kpm and 
(k2.ErrorType= "Неверный код с/п "  or k2.ErrorType= "Не указан код с/п "  or k2.ErrorType= "Не указан номер с/п" )) 
AS [Неверна или не указана с\п],
(Select Count(*) from DB_NORM as tdb where 
tdb.kpm=ke.KPM and ke.dateShort<=tdb.dt_prov and (ke.DateShort+ 1 )>=tdb.dt_prov) AS [Всего проверок]
FROM Kpm_E_s AS ke
GROUP BY ke.KPM, ke.DateShort
ORDER BY  1 ,  2 ;