November 13th, 2012, 01:53 PM
Text field numbering not showing up correctly
I have a field where the numbering is
The database is sorting the numbers
and so on.
Is there a way to keep the numbering from doing this?
November 13th, 2012, 02:29 PM
In a query, you will need to split the field into two fields. One Alpha and the other Numeric, and then sort on both fields with the Alpha to the left of the numeric. You can then hide these two fields in your query, so that your text field appears to be sorted in the manner you desire.
Office 2010, 2007, 2002
If I helped you, then click "give rep" button in the lower left corner.
November 13th, 2012, 03:43 PM
Actually, an alpha sort on those values should still work because of the placeholder zeros. Something else is going on. Maybe there isn't any sort order defined? Is that field indexed? Are you looking at table or query? Is that the actual data or result of setting Format property in table?
Last edited by June7; November 13th, 2012 at 03:46 PM.
November 13th, 2012, 04:52 PM
June is correct. I just tested and they sort properly for me when entered into a table as straight text. I did my sort in a query.