update query with multiple values
Posted
by
ozlem
on Stack Overflow
See other posts from Stack Overflow
or by ozlem
Published on 2011-01-02T14:38:12Z
Indexed on
2011/01/02
14:53 UTC
Read the original article
Hit count: 130
ms-access
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.
© Stack Overflow or respective owner