Update Qry --> Duplicate All Values

[SodaJim]

Hello,

I'm moving a field in a Table A w/ data to another Table B and would like to know if a Update Query can accomplish this...?

The field in question is not a primary or foreign key but I don't want loose the data currently stored in table A

I have copy/pasted the field into Table B; now I just need to know how to create an update qry to take data from Table A.Hours to Table B.Hours based on EmployeeID being equal...

Any direction appreciated,

 

[Jon K]

Try this Update Query (type/paste in the SQL View of a new query):-

UPDATE [Table A] INNER JOIN [Table B] ON [Table A].EmployeeID = [Table B].EmployeeID SET [Table B].Hours = [Table A].[Hours]

 

[SodaJim]

Thanks!

Thanks Jon!

Had to rework it a little, but it worked fine!