SELECT tbl_uchebnye_potoki.Vid_obucheniya, tbl_gruppy.Nomer_gruppy, tbl_uchebnye_potoki.date_open, 
tbl_uchebnye_potoki.date_end, 
Sum(tbl_sub_plan_gruppy_kolichestvo.Kolichestvo) AS [Sum-Kolichestvo], 
Count(tbl_sub_gruppy.ID_lichnyi_sostav) AS [Count-ID_lichnyi_sostav]
FROM ((tbl_uchebnye_potoki 
RIGHT JOIN tbl_gruppy ON tbl_uchebnye_potoki.ID_uchebnye_potoki = tbl_gruppy.ID_uchebnye_potoki) 
LEFT JOIN tbl_sub_gruppy ON tbl_gruppy.ID_gruppy = tbl_sub_gruppy.ID_gruppy) 
LEFT JOIN tbl_sub_plan_gruppy_kolichestvo ON tbl_gruppy.ID_gruppy = tbl_sub_plan_gruppy_kolichestvo.ID_gruppy
GROUP BY tbl_uchebnye_potoki.Vid_obucheniya, tbl_gruppy.Nomer_gruppy, 
tbl_uchebnye_potoki.date_open, tbl_uchebnye_potoki.date_end, tbl_uchebnye_potoki.Vid_obucheniya
HAVING (((tbl_uchebnye_potoki.Vid_obucheniya)="Подготовка"));