|
I think we've exhausted this discussion and reached the conclusion that despite how we think IIF should function - this is just how IIF works and we should accept it as such !?!?!?
My personal feeling at this point is that Microsoft (not Ruud) made an extremely poor naming choice in calling IIF "IIF" ... its NOT an "Immediate IF" at all - its an ass-backward conditional expression evaluator (ABCEE ?) that in no way behaves like an normal (yet compressed) IF statement.
And I think that this understanding is crucial when using IIF because you certainly wouldn't want to be calling functions that made some sort of permanent change from within an IIF because its going to get done regardless of the outcome - so maybe functions are not valid food for the IIF !!!
[ 08. January 2003, 21:02: Message edited by: Shawn ]
| 
