Microsoft Access 2003

  • Thread starter phillip.c.gibson
  • 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.
 
K

KARL DEWEY

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

Top