var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update Query based on Select Query Results
I have been searching high and low and am having difficultly figuring out how to run an Update Query based on a Select Query.
Here is the Select Query and any help would be appreciated. Thanks!
SELECT ShipmentData.Customer, Min(ShipmentData.[Date/Time]) AS [MinOfDate/Time], Min(ShipmentData.OrderNumberTrimmed) AS MinOfOrderNumberTrimmed, ShipmentData.ShipmentNumber
Note: I want to UPDATE the field "ShipmentNumber" in the ShipmentData table. Thanks!
A syntax you can use is:
UPDATE <table> SET <field> = <something> WHERE <some field> IN ( SELECT ... )
Have a nice day!