case statement using IsEmpty, question
I have 2 fields and I want to write a case statement to the following effects:
I both fields are empty to do nothing,
if both contain text give error message
and if one is empty and the other has text get the one that has text.
So I thought I would need to write a case statement for this but got lost when I had to think if 1 had text. Is there a way to make a Not IsEmpty calculation:
Case(IsEmpty(field1) and IsEmpty(field2);"";
Then I got stuck