how to Sort items by item code, in ascending or descending order
like 1 2 3
Sort items where?
why the sorting like that
Is possible the sort be like
1
2
3
11
The particular field, Item code, for inventory items is sorted as text, not numbers, because it allows both numeric and alphabetic input. Someone’s item code might be, for example, SB234 or 9567B. Sorting that way, 11 comes before 2.
So, what is the solution to sort the fields by the method described?
There is no “solution.” The program works as designed in this regard. If you want to use all-numeric codes and have them sort like numbers, make them all the same number of digits, such as:
00001
00002
00003
00011
The result of sorting these as text looks the same as sorting numerically, but you are not sorting numbers.