Search results

I am trying to figure out how to sort a column in access the same way it comes out in excel. I have a text list of "buildings" ie: 89, 33, 270C, 270B, 270A etc. In excel this simply sorts alphanumerically ie 33, 89, 270A, 270B, 270C. I made the mistake of changing the format from text to...