Just guessing here - I haven't looked up the code values - but my first instinct would be that FileMaker is evaluating the ">=" as a command to look for everything that's "greater than or equal to" the character string "10". I'd guess that the "<" symbol has a code value larger than 10, so FileMaker is returning that string as well as the one you're looking for.
Try doing your find and enclosing the ">=10" in quotes and see what you get.
If you still get the "<10" result, then I'm wrong and someone smarter than I am will have to chime in.
1 of 1 people found this helpful
That would be my guess as well
Another Option would be to change your checkbox to use text rather than the symbols "less than 10" and "10 or greater" would be easier to search and possibly more user friendly as somepeople do get confused by the < and > still.
Of course if you decide to change it, you'll need to change the data that's already been entered.
You are right. I tried to find the enclosed ">=10" on the edit box field and it returned the right answer.
Thanks for your help!
Thank you for your input. Since I do not want to change the data already entered, I just added the edit box of the same variable for searching purpose. In the future, I will try to avoid using any FM reserved operators in the value lists to make searching easier.