Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nwhiker

    Does "Switch" function have limited # of expressions?

    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"...

Part and Inventory Search

Back
Top