I want to add two fields together that are in seperate tables based on similar ID numbers through the use of a query.
Something like the following.
Table A Table B
ID Value ID Value
001 6 001 8
002 5 002 5
Results......
Table B
ID Value
001 14
002 10
I want the values to go into Table B only.
Something like the following.
Table A Table B
ID Value ID Value
001 6 001 8
002 5 002 5
Results......
Table B
ID Value
001 14
002 10
I want the values to go into Table B only.