"Update To" in update query

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

Guest

If I have two tables in an update query, why can't I update one field with
the corresponding field in another table? It just moves to the next
available column. Then, of course, it won't run. What am I doing wrong?

I am suspicious because many things that should work in this installation of
Access 2000 don't necessarily work.

Thanx
 
Hi,


UPDATE inventory INNER JOIN reception ON inventory.itemID = reception.itemID
SET inventory.unitPrice = reception.NewUnitPrice


update the unit price in inventory, accordingly to the new unit price, in
reception, for each itemID common to both tables.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top