By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & 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?

P: 4
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
Share this Question
Share on Google+
3 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
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, 537 views)
Jan 28 '11 #2

P: 4
Thanks The Smily One This works perfectly ;-)))

Cheerzzz
Jan 28 '11 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
Your welcome
Jan 28 '11 #4

Post your reply

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