The text 5 is greater than the text 40 ( and so on ).
GetAsNumber ( Trial First 40 Worked ) > 40 ; Trial First 40 Worked - 40
That did the trick! Thanks so much. I can kinda see how 5 is bigger than 40; but, then on the other hand I don't really see it. Is that comment deserving of a reply? If not, then I'm glad at least that your solution worked.
If you have 3 records with a single field of type "text" containing:
and make them sort in ascending from FileMaker, you'll get:
This is because the field is of type "text" and NOT "number"
Think of the "rules" you use to sort words into alphabetical order:
"ape" will sort before "xylophone"
because the first letter "a" evaluates as less than "x".
apply the same rules to numbers and you get the "numbers as text" order that Raybaudi has posted here.
Thanks to both of you,
I get the process now.
Have a nice day,