sorguyu aşağıdaki şekilde düzenler misiniz

SELECT Sum(ALİ.ToplaPAR_KG) AS ToplaToplaPAR_KG, Mid([RENK_NO],InStr([RENK_NO],"-")+1) AS RenkNo

FROM ALİ

GROUP BY Mid([RENK_NO],InStr([RENK_NO],"-")+1);