the above is also correct, but when i use it in microsoft access/sql, it is not working, so the below code is for micorosoft access ....but you should know how to run this code in microsoft access (there must be relationship between tables).
SELECT Customers.IdCustom, name, sum(total) as...
