Sort Output...

Sabotage1945

Registered User.
Local time
Yesterday, 19:44
Joined
Sep 30, 2004
Messages
17
[RESOLVED] Sort Output...

Hi again,

I'm working on trying to get my Query output of school grades to sort in the following manner:

A+,A,A-,B+,B,C+,C,D+,D,E,F,INC

I'm having little luck in finding a way to sort the results of table "Old_Grade", column "Entered_Mark" in the above mentioned sort. Can anyone point me in the right direction?

Thanks,
Sab.
 
Last edited:
As I recall, each letter grade got a numeric equivalent. Why not sort on the column of numeric equivalents? If it's not in your query result, join the table that has numeric equivalents, add that column to your query results, then sort on it.
 
Ah-ha! Of course!! I was so fixated in sorting the "A+" grades column I forgot about the numeric values (I had tunnel vision :rolleyes: )

Thanks for your help,
Sab.
 

Users who are viewing this thread

Back
Top Bottom