Just purchased and downloaded FM 16 Pro advanced. I have a simple number field that holds a number from 1 to 12. I have 82 records that hold mostly number 12 but a few 3, 4, and 6. When I perform a find using this field I use the operator dropdown list and select < Less Then and include 12, hoping to find everything but 12. It returns the No Records Found box. If I select the > Greater Then operator followed by 12 I get a list of all the records less then 12.
I can't seem to find anything here on the forum that cover this fir FM 16 Pro Advance.
Thanks Beverly... Just checked and it was a text field. Changed to number and it seems to be working right. I see what you are saying and I will have to watch my field types going forward. Thanks again for your explanation (happy camper).