I have an IIF() that has to evaluate one of 55 possible entries in the county field, then return one of 18 values in the district field. I tried using the IIF and typing it out, but Access says it is to complex, (not to mention tough to keep track of for me).
ex...