Search results

That seemed to do it although if there was a way to change multiple cells at the same time it would be easier. IE in excel I can select multiple cells, type what I want and hit ctrl enter and it changes them all. I wouldn't be surprised if there was more to the excel sorts then I know, I am...

that sounds like a step closer but I also need all of the 270a, 270b, 270c, 270d and 270e buildings sorted together

at the moment I have a table and a bunch of queries but if I can find a way to sort these I'll build whatever I need to

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...