Forum Discussion

Copper Contributor

Apr 02, 2022

Update query to change data in a table

Table A has: HorseID (Number), HorseName (text) Table B has: HorseID (Number), HorseName (text) I want to update Table B HorseName to be the same as Table A Horsename, the HorseID would be the same...

access

George_Hepworth

Silver Contributor

Apr 02, 2022

turniporangementions

Step one: Make back up copies of both tables, just in case.

Step two: make a back up copy of the accdb, just in case.

I wish I could use the real table names, but the Update query would be similar to this:

UPDATE TableB

INNER JOIN TableA ON TableB.HorseID = TableA.HorseID

SET [TableB].[HorseName] = [TableA].[Horsename];