"Update To" in update query

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


"Lambi000" wrote in message
...
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