Record Sorting

[rdenn_58]

I have been spending a bit of time on this problem with no solution so far. I want to sort records numerically in ascending order, but it puts larger numbers before smaller numbers.

Currently the records sort as:

1447327
1729215


535728
686713

If I sort in descending order, it shows:

686713
535728
1729215
1447327

I would like to have it sort to show:

535728
686713
1447327
1729215

I don't want to have to put a 0 in front of the 535728 or 686713 to make it work that way. This table field is a text field as a small number of records will be alpha/numeric.

Thanks for the help!!

[JoeM]

In order to get them to sort the way you want, they would need to be Numeric, not Text. But if you have alphanumeric entries, that probably isn't possible. You want two different things that are conflicting with each other (you want Text, but to sort like a Number).

Your best bet may be to create a calculated field off of this field that you use only for sorting purposes (adding in a leading zero).