?
Solved

Access 2007

Posted on 2011-09-29
2
Medium Priority
?
237 Views
Last Modified: 2012-05-12
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
Comment
Question by:jegajothy
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 36815586
run this update query

update B
inner join A on A.ID=B.ID
set B.[ACS Keyline]=A.[ACS Keyline]
0
 

Author Closing Comment

by:jegajothy
ID: 36818344
Bravo for a well answered Q. thank u.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question