I have a DB that is used to store some school related data, thngs are entered based on the semester and the year. These are separate fields within the database and we plan out outputting the data starting with the earliest year to the lastest.
Normally, this isn't a problem, but I can't guarantee that my data entry personnel will put the information in in order, so I need to order during the query.
If it were just the year I could do a order by yrinfo asc, but because I've got the semester coming into play as well I need the semester in a desc format while leaving the year in a asc format.
Unfortunately, I have none of my manuals at present to look this information up - what is the best way to format the order by statement to get things to come out as:
Spring 1998
Fall 1998
Spring 1999
Fall 1999
Etc...rather than Fall 1998, Spring 1998 and so on.
Thanks for the input!
Normally, this isn't a problem, but I can't guarantee that my data entry personnel will put the information in in order, so I need to order during the query.
If it were just the year I could do a order by yrinfo asc, but because I've got the semester coming into play as well I need the semester in a desc format while leaving the year in a asc format.
Unfortunately, I have none of my manuals at present to look this information up - what is the best way to format the order by statement to get things to come out as:
Spring 1998
Fall 1998
Spring 1999
Fall 1999
Etc...rather than Fall 1998, Spring 1998 and so on.
Thanks for the input!