I don’t know of a CASE statement in Access SQL but when I need one I use the Switch() function.
Select Switch(State=”California”,”CA”,State=”Arizona”,”AZ”,State=”New Mexico”,”NM”,True,”XX”)as Abbrev from tblStates.
This statement would return the abbreviation for the states listed. If the State was not California,Arizona nor New Mexico then “XX” would be shown. See MS Access Help for more examples and syntax rules.