Thank you Lynn, that worked superbly. "IS_MEMBER null" caused an error (An expression of non-boolean type specified in a context where a condition is expected), but when I replaced...

Thank you Lynn, I think that would work, but I'm trying to avoid using multiple SELECT statements. I'm setting a total of 11 status variables by checking approximately 40...