• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Access 2007

My OS is windows 7 and I use Access 2007.  I have 2 tables, Table A and Table B.
Both table's structure are the same.  In Table A, in addition to the ID field it also has a field called ACS Keyline.  While table B has the same field, but there are no data as the User had exported the Table but excluded this field.  How do I update Table B with the ACS Keyline field from Table A, when the ID fields in Table A and Table B are equal.  The data structure in both tables of the ID are identifical.  Hope my problem makes sense.   Please give me the steps on how to achieve them hopefully be as basic as possible.  Thank u.
0
jegajothy
Asked:
jegajothy
1 Solution
 
Rey Obrero (Capricorn1)Commented:
run this update query

update B
inner join A on A.ID=B.ID
set B.[ACS Keyline]=A.[ACS Keyline]
0
 
jegajothyretiredAuthor Commented:
Bravo for a well answered Q. thank u.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now