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.