I am using MS Access 97. In using expressions in reports it limits you to "say" 10 IFF formulas in a single expression. Does XP allow the use of more than 10 formulas in a single expression?
I am using MS Access 97. In using expressions in reports it limits you to "say" 10 IFF formulas in a single expression. Does XP allow the use of more than 10 formulas in a single expression?
I don't know if it does or not. When an expression gets
that complicated, it's better to create you own function and
use that in the text box.
OTOH, a data bound expression like that is usually a symptom
of some kind of issue in your table structure or that you
should be using a query to help sort out at least some of
whatever issue you're using all those IIf functions for.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
