Searching empty or populated fields not working.
I have a field that either has numbers in it or it does not. I know this as I have looked through the records. If I search for "=" I get all the records empty and populated. If I search for * I get no records. = should give me just the records that are empty and * should give me the records that are populated. But it's not doing that. What am I doing wrong? The control style is edit box and input method is automatic, this is FMP 13.
I should add It looks like the field itself is a calculation, specifically "count". My search is going into a script ultimately, and when I look through the records I either see nothing or numbers 1 and above.