I want my colunm in microsoft access to be sorted in alphabetical and Numerical? As in 1234abc, 2345bcd??

i think a column when ordered ascendingly will do that for you already. try sorting the column in ascending direction or if using sql, select col from table order by col asc