query part of string, then sort

  • Thread starter Thread starter jeff lane
  • Start date Start date
J

jeff lane

Thanks for that I can now query it, how do I sort the result first by those
two digits then alphabeticaly
eg.
AX02ABC
MX01ABC
MX00ABC

should read

MX00ABC
MX01ABC
AX02ABX
so that the initial sort is by the 2nd and 3rd characters in the middle and
the final sort is alphabetical
 
Dear Jeff:

Something like:

SELECT * FROM YourTable
ORDER BY Mid([SomeColumn], 3, 2), [SomeColumn]

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top