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];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top