SELECT MAIN.CODE, techproc.cm1, MAIN.COMMENT, MAIN.MARKA, matsuP.mqq, mun.measun
FROM..........
WHERE............
GROUP BY MAIN.CODE, techproc.cm1, MAIN.COMMENT, MAIN.MARKA, matsuP.mqq, mun.measun;

SELECT MAIN.CODE, MAIN.COMMENT, MAIN.MARKA, Sum(matsuP.mqq) AS [Sum-mqq], mun.measun
FROM..........
WHERE ........
GROUP BY MAIN.CODE, MAIN.COMMENT, MAIN.MARKA, mun.measun;

FROM (MAIN1 INNER JOIN (spztmp INNER JOIN techproc ON spztmp.cdtp = techproc.cm1) ON MAIN1.code = spztmp.codm1) INNER JOIN (mun INNER JOIN (MAIN INNER JOIN matsuP ON MAIN.CODE = matsuP.codm) ON mun.code = MAIN.Mun) ON techproc.code = matsuP.codetp

SELECT Sum(matsuP.mqq) AS [Sum-mqq], MAIN.CODE
FROM MAIN INNER JOIN matsuP ON MAIN.CODE = matsuP.codm
WHERE (((matsuP.codetp) In (SELECT techproc.code
FROM techproc INNER JOIN (MAIN1 INNER JOIN spztmp ON MAIN1.code = spztmp.codm1) ON techproc.cm1 = spztmp.cdtp
WHERE (((MAIN1.sernn)=[Формы]![spzcr]![serc]))
GROUP BY techproc.code;)))
GROUP BY MAIN.CODE;