Sorting records troubleshooting
Records don't sort in the correct order
 •
If numbers don’t sort correctly (11 is before 2, for example), they are entered in a field formatted to contain text data. Change the field type to Number. See About choosing a field type.
 •
 •
You might have hidden values in a field that is formatted as radio buttons or checkboxes. Values that are not on the value list do not show. To display them, add an unformatted copy of the field to a layout, then click in the field to see what it actually holds.
 •
 •
 •
 •
 •
 •
 •
 •
Records disappear after sorting
 •
Records with nothing in the sort field sort to the top of the list in an ascending sort. Scroll down (or click the book icon to page down) to see your records or omit blank records before sorting.
Sorting repeating fields
 •
 •
Related topics 
Sorting records