sql - MsAccess - How to update a column conditionally with different values -

i have database in need set different values in column dependent upon values in second column. wish (descibed in not working code think you'll understand):

update new (set domain = 'info' new.node = 'abc' or new.node = 'def') or (set domain = 'foo' new.node = 'ghi' or new.node = 'jkl')

but can't figure out how. can me?

regards // ps

use switch statement.

update [new] set [domain] = switch(     [new].node = 'abc' or [new].node = 'def', 'info',     [new].node = 'ghi' or [new].node = 'jkl', 'foo',     ); 

related link: microsoft access - case query