### Title

Sorting records by numbers with periods

### Post

How can I sort all records by an accession # that includes periods? For Example 1991.235, 1991.236, 1992.103, 1992.104

Sorting records by numbers with periods

How can I sort all records by an accession # that includes periods? For Example 1991.235, 1991.236, 1992.103, 1992.104

Then if you are sorting in ascending order and 1992.191 should come before 1992.20, I don't see the issue. Make this a field of type number and sort in ascending order.

If the second value is seen as a second integer, such that 191 is greater than 20 instead of 0.20 is greater than 0.191, then you'd need to set up two calculation fields that extract (parse) the the numbers from before and after the decimal so that you can use those two fields in tandem in a specified sort order.

Is there only ever 1 decimal in these numbers?

Should

1992.20

come before or after

1992.191

??