When you have separate questions please ask them in their own thread to make them easier to find for others to answer.
In your question does “value exists” mean? More particularly, what’s the field being referred to by value?And what is the test of existence? That the “value” is not Null? Or something else?
I branched this into a new Discussion. Good suggestion, Jonathan!