I have a table called tblPlayers with a column called ScheduleYear.
In the column ScheduleYear, there are entries like:
I want to create a SELECT DISTINCT query that displays them in that order (Descending by Year with Fall first, then Summer). The data never deviates from that convention. It is always a year preceded by the word "Fall" or the word "Summer."
How would I do this?