[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

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
 
0
sjercich
Asked:
sjercich
3 Solutions
 
mmconsultantCommented:
Can we assume that A, B, C and D are some field containing unique values?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not sure what you mean by 'superimpose'

mx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 MVP, Access and Data Platform)Commented:
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
 
mmconsultantCommented:
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
 
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 MVP, Access and Data Platform)Commented:
"3) Link the unique fields by dragging one onto the other "

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

mx
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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