"Update To" in update query

L

Lambi000

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
 
M

Michel Walsh

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
 
Top