update query with multiple values
- by ozlem
I want to write an update query in MS Access 2003. I have a field called product_code.
If product code is (between 110 and 752) OR (between 910 and 1124), I want to update product code=15.
If product code is (between 1210 and 1213) OR (1310 and 1423) I want to assign product code=16.
If product code is some other value I will assign 18, and so on
I don't think I can use CASE statement for this since I have many values to be updated. I tried to use multiple UPDATE/SET statements but it didn't work.