Update Query not posting

[Bill 32301]

When I run an update query using tables in the same database, records are
selected, but new data is not posted to fields in my main table. If I run
the same as an append, the new data is added in fields to the table as new
records. How do I get the update to post in the appropriate fields?

Microsoft Office Access 2007 Database

Any answers as to a solution?

 

[Michel Walsh]

If you want to update the unitPrice from a newList to an inventory table,
adding new records for new itemID and simply updating the unitPrice of the
existing ones:


UPDATE inventory RIGHT JOIN newList
ON inventory.itemID = newList.itemID
SET
inventory.itemID = newList.itemID,
inventory.UnitPrice = newList.UnitPrice




would do, with Jet.


Vanderghast, Access MVP

 

[John W. Vinson]

On Fri, 20 Feb 2009 07:53:01 -0800, Bill 32301 <Bill

When I run an update query using tables in the same database, records are
selected, but new data is not posted to fields in my main table. If I run
the same as an append, the new data is added in fields to the table as new
records. How do I get the update to post in the appropriate fields?

Correct the (apparent) error in your update query.

If you would like help doing so please open it in SQL view and post the SQL
text here, so the volunteers can see what you're doing!

It may help to also indicate which field(s) constitute the Primary Key, and
any relationships between the tables.