Posted on 2012-03-28
I am trying to order my recordset by the last 1 or 2 numbers from a value that always starts with a letter. For example the value is B10, I want to order it by 10.
So what is the syntax for this in ORDER BY?
Here is the sql. The ORDER BY row has psuedo code.
strSql = "SELECT ServCat, Number, Division, Coded, Reason, ServCatDesc " _
& "FROM tblServCats " _
& "WHERE Div = '" & vDiv & "' " _
& "ORDER BY mid(ServCat , 1, 2)"