SELECT gaga_tblOborud.Oborud,
IIf(IsNull(qrySubOborud1![Count-OborudID]), 0 ,qrySubOborud1![Count-OborudID]) AS kolOborud
FROM gaga_tblOborud LEFT JOIN 
[SELECT gaga_tblModel.OborudID, gaga_tblModelARM.ARMID, Count(gaga_tblOborud.OborudID) AS [Count-OborudID]
FROM gaga_tblOborud
RIGHT JOIN (gaga_tblModel RIGHT JOIN gaga_tblModelARM ON gaga_tblModel.ModelID = gaga_tblModelARM.ModelID)
ON gaga_tblOborud.OborudID = gaga_tblModel.OborudID
GROUP BY gaga_tblModel.OborudID, gaga_tblModelARM.ARMID
HAVING (((gaga_tblModelARM.ARMID)=armid()))]. As qrySubOborud1
ON gaga_tblOborud.OborudID = qrySubOborud1.OborudID
WHERE (((gaga_tblOborud.GrupOborudID)= 1  Or (gaga_tblOborud.GrupOborudID)= 2 ));

function armid()
armid=[Forms]![frmQryStaff]![frmQryARM].[Form]![ARMID]
end function