SELECT Objects_Perechen.ID, Objects_Perechen.OST,
 Type_MN.Type AS Type_MN_Type, Objects_Perechen.MN,
 Objects_Perechen.NameRiver, Objects_Perechen.Line, Objects_Perechen.Piket,
 Report_Perechen.Number, Type_work.Type AS Type_work_Type, Type_object.Tp,
 KtrAgent_Perechen.Name_KtrAgent, Report_Perechen.DateIn,
 Report_Perechen.DateOut, Report_Perechen.DateCheck, Report_Perechen.Checking, 
Sum(IIf(Z.kod_zamech="К1",1,0)) AS N1,
 Sum(IIf(Z.kod_zamech="К2",1,0)) AS N2,
 Sum(IIf(Z.kod_zamech="К3",1,0)) AS N3,
 Sum(IIf(Z.kod_zamech="К4",1,0)) AS N4,
 Sum(IIf(Z.kod_zamech="К5",1,0)) AS N5,
 Sum(IIf(Z.kod_zamech="К6",1,0)) AS N6,
 Sum(IIf(Z.kod_zamech="К7",1,0)) AS N7,
 Sum(IIf(Z.kod_zamech="К8",1,0)) AS N8,
 Sum(IIf(Z.kod_zamech="К9",1,0)) AS N9,
 Sum(IIf(Z.kod_zamech="К10",1,0)) AS N10,
 Sum(IIf(Z.kod_zamech="К11",1,0)) AS N11
FROM Zamech_kod
 INNER JOIN ((((Type_MN
 INNER JOIN MN_Perechen
  ON Type_MN.[ID] = MN_Perechen.[Type_MN])
 INNER JOIN (Type_object
 INNER JOIN Objects_Perechen
  ON Type_object.[ID] = Objects_Perechen.[Type])
  ON MN_Perechen.[ID] = Objects_Perechen.[MN])
 INNER JOIN (Type_work
 INNER JOIN (KtrAgent_Perechen
 INNER JOIN Report_Perechen
  ON KtrAgent_Perechen.[ID] = Report_Perechen.[KtrAgent])
  ON Type_work.[ID] = Report_Perechen.[Work])
  ON Objects_Perechen.[ID] = Report_Perechen.[Object])
 INNER JOIN Zamech_Perechen AS Z
  ON Report_Perechen.Number = Z.Number_Report)
  ON Zamech_kod.ID = Z.kod_zamech
GROUP BY Objects_Perechen.ID, Objects_Perechen.OST, Type_MN.Type,
 Objects_Perechen.MN, Objects_Perechen.NameRiver, Objects_Perechen.Line,
 Objects_Perechen.Piket, Report_Perechen.Number, Type_work.Type,
 Type_object.Tp, KtrAgent_Perechen.Name_KtrAgent, Report_Perechen.DateIn,
 Report_Perechen.DateOut, Report_Perechen.DateCheck, Report_Perechen.Checking;