SELECT Table1.ID, Sum(Table1.maas) AS Toplamaas, Sum(Table1.mesai) AS Toplamesai, Sum(Table1.prim) AS Toplaprim, Sum(nz([maas],0)+nz([mesai],0)+nz([prim],0)) AS toplam
FROM Table1
GROUP BY Table1.ID;
.....
bunu sorgu olarak yap