How to add a value from a record in Table A to a record in table B if the value is?

[debo sniffa]

I want to add a value from a record in Table A to a record in table B if the value is same as 2 other fields in the Table A.

How could i get this done in access??

Pls help me... ;-)

[TheSmileyCoder]

Open your query design window, add Table A and Table B to the window. Draw a line between the Field in Table A that you want to compare with the field in table B (Do this for both fields)

Then set the query type to Update Query, add the Field you wish to update to the bottom list of fields, and then in the Update field simply type TableA.Field1.

It could look something like this (Access 2003):

[debo sniffa]

Thanks The Smily One This works perfectly ;-)))

Cheerzzz

[TheSmileyCoder]

Your welcome