Sort Output... (1 Viewer)

[Sabotage1945]

[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.

 

[dcx693]

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.

 

[Sabotage1945]

Ah-ha! Of course!! I was so fixated in sorting the "A+" grades column I forgot about the numeric values (I had tunnel vision )

Thanks for your help,
Sab.