I have a problem with the numeric sort.In a column I the numeir from 1 to 2000.When I order the result is:110101102..11...2Instead I would like to keep sorting 1 2 3 4 .... 2000.how can I do?
that field (column) is probably defined as Text - you'll need it to be defined as number to sort as you'd like.
There are other options though, like adding leading zeroes (001, 052, etc.) and/or creating a calculated field to sort on instead.
Have you defined your field at a text field instead of a number field?
It's true I had mistakenly put as text.Putting it as numeric resolved.Thank you.
Retrieving data ...