Use one field's values to update another field

Guest · Oct 14, 2003

Can you sort by something in an update query? I want to update numbers in one
field based on dates in another.
[email protected]

Michel Walsh · Oct 14, 2003

Hi,

We can always update a table from values from another table, but I fail
to see the "sort by" implication, at the moment. With Jet:

UPDATE inventory RIGHT JOIN newArrival
ON inventory.ProductID=newArrival.ProductID

SET inventory.ProductID= newArrival.ProductID,
inventory.UnitPrice=newArrival.UnitPrice
inventory.Description = newArrival.Description

Hoping it may help,
Vanderghast, Access MVP

Use one field's values to update another field

Guest

Michel Walsh