Using IF..ELSE in UPDATE (SQL server 2005 and/or ACCESS 2007 ...

UPDATE XXXXXX IF column A = 1 then set column B = 'Y' ELSE IF column A = 2 then set column C ...

stackoverflow.com