Hello,
I am generating a report,
Trying to do If box 1 equals Yes, insert "text"
If box 2 equals Yess, Insert "text"
The problem is that in nested if and regular iff the expression stops as soon as it finds a true value. Regular IFF creates formatting problems because say I have ten items and only two are Yes, then on the report I'll have
"Text1"
8 blank lines
"Text2"
when what I am really trying to do is have text2 (or whatever of ten items equals Yes) underneath text1.
Isn't there some way to solve this problem, maybe visual basic? I'm no expert, any help is welcome.
I am generating a report,
Trying to do If box 1 equals Yes, insert "text"
If box 2 equals Yess, Insert "text"
The problem is that in nested if and regular iff the expression stops as soon as it finds a true value. Regular IFF creates formatting problems because say I have ten items and only two are Yes, then on the report I'll have
"Text1"
8 blank lines
"Text2"
when what I am really trying to do is have text2 (or whatever of ten items equals Yes) underneath text1.
Isn't there some way to solve this problem, maybe visual basic? I'm no expert, any help is welcome.
