
Originally Posted by
cbgroves
Hey everyone,
I am relatively new to Access and have been setting up a pretty simple database to track some things at work. I have been able to figure most everything out except a sorting issue in a report that I need. I am sorting by semester, ie spring 2011, summer 2011, fall 2011, spring 2012 ect. My problem is I need them to go in that order, by the academic calendar. I cannot figure out how to sort by anything other than alphabetically and I do not want to add random characters to make it sort correctly. Can what I want to do be done?
Thanks!
Calvin