Alphanumeric sort

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

This is probably ridiculously simple, but I'm new to
Access and can't seem to figure this out.

How do I do an alphanumeric sort, where letters A-Z would
come first, followed by numbers 0-9?

Example: 123, Green, 234, Blue

Should sort: Blue, Green, 123, 234

-Dave
 
Interesting one. Good explanation by the way. I would
create a query with an expression field (e.g. Sortvalue).
It doesn't have to show-up anywhere - just sort with it.
What you could do is add the string "0000" in from of the
text strings only.

The expression would be:
Sortvalue: iif([yourfield]>0, [yourfield], "0000"+
[yourfield]).

sortvalues
0000Blue
0000Green
123
124

Kevin
 
Back
Top