Update item numbers from another table

H

Harv

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
 
M

[MVP] S.Clark

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
 
Top