G Guest Oct 12, 2006 #1 I have a column in MSAccess that contains alphanumeric characters. I wish to sort it in a numeric order. How do I do that?
I have a column in MSAccess that contains alphanumeric characters. I wish to sort it in a numeric order. How do I do that?
J John Vinson Oct 12, 2006 #2 I have a column in MSAccess that contains alphanumeric characters. I wish to sort it in a numeric order. How do I do that? Click to expand... If you sort by Val([fieldname]) Access will extract the leading number. If you have data like ABC122, QWEQW315 and X65, it'll be more work - since these don't start with a number, Val() will return 0 for all of them. John W. Vinson[MVP]
I have a column in MSAccess that contains alphanumeric characters. I wish to sort it in a numeric order. How do I do that? Click to expand... If you sort by Val([fieldname]) Access will extract the leading number. If you have data like ABC122, QWEQW315 and X65, it'll be more work - since these don't start with a number, Val() will return 0 for all of them. John W. Vinson[MVP]
