"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
 
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

DSum update query with multiple fields 0
update query 2
Update Query Help *urgent* 0
Update query issue 0
update query vs make query 5
Update primary key field with multiple "where" clauses 0
problem with update query 4
query is not updatable;; urgent 1

Back
Top