Subselect in an Update query

[Ed Reed]

Can anyone tell me how I can make this work or suggest a work around?
 
Update table1 Set field1=(Select field1 From table1 Where field2="Some Value") 
Where field2  ="Another Value";
 
Thanks