Adding values in one field to values in another table with a query

[redaccess]

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.

 

[gusbrunston]

Hi,

You may have some difficulty with advice on this unless it is further explained. You want to store calculated values: against "the rules of normalization". Values should be recalculated with each form, report, etc. There are exceptions, but I have yet to discover what they are!

Good luck Gus Brunston An old PICKer, using Access2000
padregus@attbi.com

 

[zzAdm]

In the instance above the SQL below taken from Access would work:

UPDATE [Table A] INNER JOIN [Table B] ON [Table A].ID = [Table B].ID SET [Table B].[Value] = [Table A]![Value]+[Table B]![Value];