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 thirs 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.

 

[Guus2005]

This is not common practise to duplicate tables. Why would you do that?

My advice, add an identifier and just use one table:
Table1
- ID
- Salary
- Interest (shouldn't be here either)
- Bonus

Redundant information such as you suggest could only prove usefull in a datawarehouse. With an extreem large number of records or fields.

HTH