another update problem

[slimjen]

how do i create an update query where update a field based on criteria in another field: ie

 
update table
set[shippercountry]=northeast if [shipper state] = "VA" or "SC"

Thanks

[June7]

Try:
UPDATE tablename SET [shippercountry] = "northeast" WHERE [shipper state] = "VA" OR [shipper state] = "SC";

Would not need to do this if you had a table of States with the Region as a field.