Search results

I'm not really finding any helpful solutions through my own search process, and I was wondering if you guys would be able to help me. I have a query containing information about students that has the following columns: [NAME], [CLASS], [GROUP], [StudentE Mail]. I also have a word document...

I have a column containing an id that consists of the first two letters of a weekday followed by an incrementing number. For example, for Monday, I have "MoA1" "MoA2" "MoA3" ... "MoA11". The problem is that when I sort my list, it is ordering it: "MoA1" "MoA10" "MoA11" "MoA2" "MoA3" etc...