I am trying to sort first by year then by term (i.e. summer, fall, spring) for a school year. I know how to do custom sort so i set up a list. The problem comes here:

Term Year

Spring 2002
Summer 2002
Summer 2002
Summer 2002
Summer 2003
Summer 2003
Summer 2004
Summer 2004
Summer 2004
Summer 2004
Summer 2004
Summer 2004
Fall 2005
Summer 2005
Summer 2005

Because there is no spring 2005, the last entry it sees is summer so it puts fall 2005 when in reality i want summer 2005 next. How do i sort so that any time there is a new year in the year column, it starts the sort over with spring in the term column? Thanks!