Q:

Update totals in another table when changes made to the current table

I have this table
ID       Name      Price

 1       John        12 €
 2       John        35 €
 3       Alex        15 €
 4       Alex        12 €
 5       James       10 €

I need a query that update a field in another table, summing up all the values in price field that have the same name. For example the results of the query in this case would be:
ID       Name      Price

 1       John        47 €
 2       Alex        27 €
 3       James       10 €

A:

With Access 2010 and later we can use Data Macros to accomplish this:

