I am trying to get a return on a field using "is null", but all I get is an empty query. I can filter on the field, but the I can't get the data to save that way. This field worked up until about 4 weeks ago. Any suggestions?
I am trying to get a return on a field using "is null", but all I get is an empty query. I can filter on the field, but the I can't get the data to save that way. This field worked up until about 4 weeks ago. Any suggestions?
I've had instances when Is Null returns nothing - but it has been because there were no Nulls in the field.
You can try looking for Empty string instead or " " instead?
What is the actual SQL of the query? And how are you trying to save the data?