Does "Switch" function have limited # of expressions?

[nwhiker]

I am trying to run a query using "Switch" function in Access 2003, e.g. Switch (VAR1=1 AND VAR2=5, "A"), (VAR1=2 AND VAR2=7, "B")... I've got about 20 expressions. Looks like Access 2003 only allows 14 expressions otherwise it gives me error message "expression too complex in query expression". What would be a right way to created a new field based on many different expressions (conditions)? Thanks.

 

[PHV]

Create your own function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

I would either follow PH's advice or possibly model the value lookup in tables.

Duane MS Access MVP
Now help me support United Cerebral Palsy