Sorting records troubleshooting
• 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.
•