By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,401 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

MS Access 2003 Maximum number of values in a CHOOSE function

P: 1
I'm using Access 2003 and have a CHOOSE function in a query. I can use up to 28 values with no problem, but when I add the 29th value,I get the message "The expression you entered is too complex". I thought the limit was something like 256 values but I'm thinking I'm at the max with 28. I've received this same message when I try to nest too many IIF statements. Any suggestions?
Oct 26 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 100+
P: 2,321
If you are using that many choose options it sounds like you might benefit from using a sub-query or vba code. Without more details on what you are trying to accomplish and how, we can't really provide any more usefull help.
Oct 26 '12 #2

Expert Mod 15k+
P: 31,494
My suggestion would be to put the choices into a table when they get to more than three or four. Benefits are that the design is much clearer and the execution is much quicker. A natural follow-on from the first point is that it's easier to maintain in the longer term too.

Using Choose() rather than IIf() is a good sign that you're thinking about what you do mind.
Oct 27 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.