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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

retrieving duplicate records from multiple tables 1
SUM in grouped query? 1
Replace a value with the one above it in a field 6
Limiting results from one side of a join conditionally 1
append query 1
Help I trying to query from importing data from AS400 1
autonumber queestion 3
Access Query Expression - Extremely Urgent!!! 3

Back
Top