Update item numbers from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I hope you can help.

I have table0 that holds information such as [procedure], [itemNumber],
[qty]. Another table, table1 that has [oldItemNumber], [newItemNumber]. I
need to change the [itemNumber] in table0, that matches with [oldItemNumber]
to [newItemNumber].

Any suggestions for an update query would be appreciated.

Thanks
Harv
 
Add both tables to the query. Link by the desired field.
Change query type to Update.
Add the ItemNumber field to the grid
Specify the new value in the Value row to NewItemNumber
 
Back
Top