addition of data in two tables

[kingking]

i have two tables - all fields are same in two tables.

Table1.salary, Table1.Interest, Table1.Bonus
Table2.salary, Table2.Interest, Table2.Bonus

now i want to add these values and put in a third table.

Table3.salary=Table1.salary+Table2.salary
Table3.Interest=Table1.Interest+Table2.Interest
Table3.Bonus=Table1.Bonus+Table2.Bonus

pls help me.
can i do it with help of Query, Macro or any other method.

 

[b4rt07]

What are you trying to achieve? At the least, you need something to join them on?

 

[The_Doc_Man]

Please do not double-post.