I am trying to write Access SQL statement but without success.
So, I have Column "Division" and there I have BNW, BNB, WNB etc.
Now I want to create an UPDATE or IFF statement to update the above names as:
BNW = black & white
BNB = black & black
WNB = white & black.
I try with this UPDATE - but not working
SET Division = CASE Division
when 'BNW' then 'black & white'
when 'BNB' then 'black & black'
when 'WNB' then 'white & black'
where Division in ('BNW', 'BNB', 'WNB')
Any suggestions or idea how to fix this?
Thank you in advance.