Update Query in Access 2002

  • Thread starter Thread starter Keith Fentress
  • Start date Start date
K

Keith Fentress

I have multiple tables where i need to make a chane to one
column in each of the tables. Here is my Scenerio:

Football League Database where players ID's need to be
modified. I have created a new Table with the Old_ID and
then New_ID and now I need to run an update query to
change the old ID to the NEw ID,

I am totally not understanding how to do this. Can
someone PLEASE Help...

Thanks in Advance
 
Could you elaborate? I am an idiot when it comes to
Queries.

How do I set this up. I have a Table that I created with
the 2 columns, One has the OLD_ID and one has the
NEW_ID. So how do I set this up?

Thanks in Advance
 
Back
Top