[AccessD] Sort mixed alpha numeric data

John Bartow john at winhaven.net
Mon Jun 16 18:27:15 CDT 2003


I have a test field where the data is generally 1,2,3,4,5 but can also
include 1a, 1b, 1c.

Would any one happen to have ideas for a way (or code for a function that
will) sort mixed data numerically first and then alphabetically?

TIA
JB

PS: This is the way it is and there is no way there is going to be any
additional fields added to the table.




More information about the AccessD mailing list