how to sort a column of alphanumeric data

G

Guest

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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 4 characters alphanumeric data validation check on one excel column. 1
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Excel Help creating Excel formula 1
filter column unique for alphanumeric 3
how to do data validation in excel 1
iif, len, replace queries - need assistance 1
Using expression builder to format a report field 4
sort recorts 3

Top