I am trying to produce a complex set of IIf statements within each other. the idea is to provide user with input on complex issues and what to be aware of in certain situations. I may do so by producing a number of IIf statements, possibly in separate queries, but I want to compress a lot of information in a single comprehensive user feedback expression.
But there is a limit to how much text I can write, even when using the generator to make the expression. Is there a workaround to generate really long pieces of expressions, perhaps by putting the text provided as feedback to the user in a separate place, like in a separate table?