iamchemist
Programmer
I have a need to write an expression in a Query, which performs two conditional tests at once. That is, something like "If X is true and Y is true, then print Name", or "If X=N and Y=M, then print Name". It would be ideal if the Immediate IF Function (IIf) would allow two tests within the statement, but as far as I can tell it will only allow one.
I am aware that what I want to do can be done with VBA Code (although I'm not really sure how to do it), but I'd rather not have to go that route.
Any ideas?
Thanks,
Ron
I am aware that what I want to do can be done with VBA Code (although I'm not really sure how to do it), but I'd rather not have to go that route.
Any ideas?
Thanks,
Ron