I have designed a query in MS Access and have set the sort order to Ascending. This sorts the data in that field by (0-9) (A-Z).
I need to change that default to sort first by the alpha then by numeric: (A-Z) (0-9).
I am using Access 97.
Thanks in advance for any assistance you can provide.
M Mayberry
