Microsoft Access 2003

  • Thread starter Thread starter phillip.c.gibson
  • Start date Start date
P

phillip.c.gibson

I have 2 tables (lets call them A and B). In both tables is a column for the
employee ID numbers (so I can match these ). I need to find a way to update
table A with the data from table B for any records taht match in both for
employee ID number. Example : In Table B employee 123456789 has 8.99 hours
of PTO time. I need to bash this against Table A locate the record that is
for employee 123456789 and update his PTO cell in his recrod and update it to
reflect the same value as in Table B.
 
BACKUP DATABASE BACKUP DATABASE

UPDATE TableA INNER JOIN TableB ON TableB.EmployeeID = TableB.EmployeeID SET
TableA.PTO= [TableB].[PTO];
 
Back
Top