Query Expression Size Limits

[codedog]

I know this isn't a VBA problem or question, but any help would be greatly appreciated.

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's been truncated by this thoughtful software.

Any ideas, solutions? Thanks for any consideration.

 

[riny]

Sorry for being over simple, but just make sub queries that feed into a main query.

Another thought is to reduce the field name sizes.
Eg a field called "customer reference ID" could win space if it is changed to "C ID"