Sum Column with conditions

[g8rnc]

Hopefully you guys can help me, I'll try to keep this as simple as possible while still being descriptive enough. Here's what I'm trying to accomplish:

In Table1 I want to sum all the numbers from Column1 if they have the same number in Column2. For example, these would be added:
Column1 Column2
----1----------5
----2----------5


----3----------5
----4----------4 (Not added)

The sum in this example should be 6 (3+2+1).

Also, I want to take this sum and place it in a field in Table2 that has the same number from Column2 (Table1) as Column2 (Table2). So in my previous example the sum that equals 6 would be put in Column2, Table2 under the entry for 5. The sum that equals 4 would be placed in Column2, Table2 under the entry for 4.

Column2 in Table2 is the primary key, so there are no multiples for that.

[ConneXionLost]

Calculated fields (sums) should not be put in a table; a query is preferrable:

SELECT Table1.Column2, Sum(Table1.Column1) AS SumOfColumn1
FROM Table1
GROUP BY Table1.Column2;

Cheers,