AnsweredAssumed Answered

Find Operators Reversed

Question asked by kdr on Mar 31, 2018
Latest reply on Mar 31, 2018 by beverly

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.

Outcomes