Use one field's values to update another field

G

Guest

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

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
 

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

Autonumber field in Excel that behaves the same as Access 0
Making a macro only work on certain files 2
MS Project Center-Autolink column fields 0
Embed the same Excel multiple times 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
ASK Field Formatting 1
Copy previous record into form field 0

Top