How to superimpose data from one Access table into another Access table

I would like to superimpose the data from one Access table over data in another Access table.  For example,
Table A
 A  0
 B  0
 C  0
 D  0

Table B
B  6.7
C  3.7

Result after superposition
Table A
A  0
B  6.7
C  3.7
D  0

Can you tell me how to do this in Access?
Thank you,
Scott J
 
sjercichAsked:
Who is Participating?
 
mmconsultantOwnerCommented:
1) Create an new query.
2) Add your two tables
3) Link the unique fields by dragging one onto the other
4) Drag field you want to update from table A down to the grid.
5) place [TableB].[ValueField] in the update box (Obviously <ValueField> is the name of your field containing the data and shouldn't be taken literally.
6) run the query.

0
 
mmconsultantOwnerCommented:
Can we assume that A, B, C and D are some field containing unique values?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
An update query?

UPDATE TableA INNER JOIN TableB ON TableA.A = TableB.A SET TableA.A = [TableB].[A], TableA.B = [TableB].[B], TableA.C = [TableB].[C], TableA.D = [TableB].[D]

mx
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not sure what you mean by 'superimpose'

mx
0
 
sjercichAuthor Commented:
Yes... A, B, C and D are all unique values.
Thanks for the proposed solution.  Can you tell me how to do it using Access without using SQL?  I am not too familiar with SQL.
Thank you,
Scott J
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Actually, what I proposed probably won't work.

Is there a common field between Table A and Table B ... ie, they need to be 'joined' in some way.  And again, what do you mean by superimpose ?

mx
0
 
InnovativeLogicCommented:
mmconsultant has it!
only one step missing would be
4b) change to an update query by going to meu item Query>>Update Query and then following on.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"3) Link the unique fields by dragging one onto the other "

If we knew what they were or if there are any.

mx
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.

All Courses

From novice to tech pro — start learning today.