AnsweredAssumed Answered

Find Operators Reversed

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

Like • Show 0 Likes0
Comment • 3

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.

kdr Mar 31, 2018 7:33 AM

Correct Answer

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).

See the reply in context

No one else had this question

Outcomes

beverly

Mar 31, 2018 11:14 AM

Can you verify that the field is a NUMBER & not text? I've just created a sample that has a TEXT field (with the number value) and when I search, I get the results you did (seems to be "reversed"). But when I search a number field (same values), I get the correct results (as they should be}.

Remember that a number in a TEXT field is text and "12" is the text character "1" followed by the "2" character. If you sort this type of field:

12
12
12
12
12
12
12
12
3
3
3
4
4
4

See what happened? So your comparison is a Text comparison, not numerical.

Beverly

2 people found this helpful

Actions

kdr Mar 31, 2018 7:33 AM

Actions

beverly

@ kdr on Mar 31, 2018 7:42 AM

Well, you can do a find in a Text field. But you have to "think-text", as my sort example showed. But because you want a number search, it's just easier to make it a number field for comparisons that should be numerical.

Actions

3 Replies

beverly Mar 31, 2018 11:14 AM
Mark Correct
Correct Answer
Can you verify that the field is a NUMBER & not text? I've just created a sample that has a TEXT field (with the number value) and when I search, I get the results you did (seems to be "reversed"). But when I search a number field (same values), I get the correct results (as they should be}.

Remember that a number in a TEXT field is text and "12" is the text character "1" followed by the "2" character. If you sort this type of field:
12
12
12
12
12
12
12
12
3
3
3
4
4
4

See what happened? So your comparison is a Text comparison, not numerical.
Beverly
2 people found this helpful
Like • Show 1 Like1
Actions
kdr Mar 31, 2018 7:33 AM
Unmark Correct
Correct Answer
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).
Like • Show 1 Like1
Actions
beverly @ kdr on Mar 31, 2018 7:42 AM
Mark Correct
Correct Answer
Well, you can do a find in a Text field. But you have to "think-text", as my sort example showed. But because you want a number search, it's just easier to make it a number field for comparisons that should be numerical.
Like • Show 0 Likes0
Actions

Find Operators Reversed

Outcomes

Related Content

Recommended Content