SELECT IIf(InStr(1,[champ1]," ")=0,[champ1],Left([champ1],InStr(1,[champ1]," ")-1)) AS PremMot, Sum(Table1.Champ2) AS SommeDeChamp2, Sum(Table1.Champ3) AS SommeDeChamp3
FROM Table1
GROUP BY IIf(InStr(1,[champ1]," ")=0,[champ1],Left([champ1],InStr(1,[champ1]," ")-1));