Gender  Goesby  LName  MarriedName  NameToday  
F  Penny  McMaker  Baker  Penny Baker  
F  Reesa  Rainmaker  Reesa Rainmaker  
M  Fred  Freeloader  Fred Freeloader 
update HCL
set masterAchieved = 'Yes'
from HCL
where gamertag in (select gamertag
from HCL
where medalsleft = 0)
Buyer Item InStock ShipAll
4 Stove90 Yes
8 Mit23 No
10 Cap12 No
4 Game01 No
6 Genie21 Yes
6 Glove33 Yes
UPDATE shipments SET shipments.ShipAll = 'Yes' WHERE (((shipments.InStock)='Yes'));





N/A  

Yes  

Yes  Yes  

N/A  

N/A  

N/A  

N/A  

No  Yes  

N/A 
This formula returns a "Yes" if any of the same IDs have different "PCP In?" values. Given the same table in Access, is there an update query that can be used to mimic this formula's return? Any help is greatly appreciated! 
Sales Order  Item  Qty  Stock 
A1  X  10  50 
A2  Y  25  150 
A3  X  15  40 
A4  X  10  25 