I'm trying to build a query expression that has nested IIf's. The help says that it's limited to 1024 characters. Once my query expression exceeds 512 characters and I try to save it, I get a message about an incomplete IIf. Then when I zoom on the expression, it gets truncated by this thoughtful software. Any ideas, solutions? Thanks for any consideration.
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!
-
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!
Size limits for query expressions
- Thread starter codedog
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question