Update information from one table to another

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello all, I am new to this group so hopefully somebody can help me
here

Scenario:
I have two tables, Table A and Table B: this tables are linked. What I
want is create a query that will update the information from Table B to
Table A. I am pretty familiar with Access but this is the first time I
new to do this, so thats why I am asking for some help.
Both tables contains exactly the same fields, so I just want to
basically update the information from one table to the other

Thanks you in advance
 
Hello all, I am new to this group so hopefully somebody can help me
here

Scenario:
I have two tables, Table A and Table B: this tables are linked. What I
want is create a query that will update the information from Table B to
Table A. I am pretty familiar with Access but this is the first time I
new to do this, so thats why I am asking for some help.
Both tables contains exactly the same fields, so I just want to
basically update the information from one table to the other

Thanks you in advance
Click to expand...

Just bear in mind that this should NOT be a routine operation. Storing
the same data redundantly in two different tables should very rarely
be necessary!

John W. Vinson[MVP]
 
Back
Top