G Guest Oct 14, 2003 #1 Can you sort by something in an update query? I want to update numbers in one field based on dates in another. (e-mail address removed)
Can you sort by something in an update query? I want to update numbers in one field based on dates in another. (e-mail address removed)
M Michel Walsh Oct 14, 2003 #2 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
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
