469,275 Members | 1,791 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

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

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... ;-)
Jan 28 '11 #1
3 1913
TheSmileyCoder
2,321 Expert Mod 2GB
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):

Attached Images
File Type: jpg UpdateQuery.JPG (18.7 KB, 579 views)
Jan 28 '11 #2
Thanks The Smily One This works perfectly ;-)))

Cheerzzz
Jan 28 '11 #3
TheSmileyCoder
2,321 Expert Mod 2GB
Your welcome
Jan 28 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Andrew | last post: by
1 post views Thread by Bernd Smits | last post: by
9 posts views Thread by Joshua.Buss | last post: by
5 posts views Thread by littlevikinggirl | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.