AnsweredAssumed Answered

Searching empty or populated fields not working.

Question asked by crow on Jun 9, 2015
Latest reply on Jun 15, 2015 by crow

Title

Searching empty or populated fields not working.

Post

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.

Outcomes