Holly_Associated
Registered User.
- Local time
- Today, 13:22
- Joined
- Mar 21, 2013
- Messages
- 53
Hi All,
I am trying to use a six nested iif statements to evaluate to one line of text from three fields.
I have made a table of possible outcomes and written each condition and truepart from it, with a seventh line being the falsepart on the end. I use this with the expression builder to make the full expression, just copying and pasting and inserting the commas where needed. It usually works for me!
I have attached a tester db, and a shot of my table for reference. The thing is, with my tester data in the table, lines 4 and 6 do not evaluate properly but the rest do.
I've tried rearranging the order of the "is null" and "is not null", the order the fields appear in and the order the "and" appear in. I'm sure I've double and triple checked my parentheses but I've been troubleshooting this for over an hour now and its time to call in the back up.
If anyone can see where I've gone wrong I'd much appreciate you pointing it out! Alternatively, if you know of a more efficient way for me to achieve the same result using VBA or SQL and don't mind explaining it, I'd love to hear it too!
* Crosses fingers and hopes its not a blooming comma or bracket in the wrong place *
Thanks,
Holly
I am trying to use a six nested iif statements to evaluate to one line of text from three fields.
I have made a table of possible outcomes and written each condition and truepart from it, with a seventh line being the falsepart on the end. I use this with the expression builder to make the full expression, just copying and pasting and inserting the commas where needed. It usually works for me!
I have attached a tester db, and a shot of my table for reference. The thing is, with my tester data in the table, lines 4 and 6 do not evaluate properly but the rest do.
I've tried rearranging the order of the "is null" and "is not null", the order the fields appear in and the order the "and" appear in. I'm sure I've double and triple checked my parentheses but I've been troubleshooting this for over an hour now and its time to call in the back up.
If anyone can see where I've gone wrong I'd much appreciate you pointing it out! Alternatively, if you know of a more efficient way for me to achieve the same result using VBA or SQL and don't mind explaining it, I'd love to hear it too!
* Crosses fingers and hopes its not a blooming comma or bracket in the wrong place *
Thanks,
Holly