Placing a person in Best grading

[naungsai]

Dear Friends

I have a table with varibles like GDate, Code and Grade.
"Code" is code number of person. "Grade" is grading of that particular for the "GDate" which is a date value.

I want to evaluate each person in grading for a peirod of within 6 month.
But for the grading, I don't want to know his all grade. I want to know his best grade. For example, within 6 month period, if s/he is in a grade "A", I will say that s/he is grade "A" reguadless of how many grade "B" or "C", s/he got in that period.

A is the highest, B the middle and C the lowest grade.

Help me please.

Happy new year.

 

[namliam]

Use a "group by" query and get the MIN value of the grade...

This sounds contradictory but in database terms A is lower than B, so MIN in this case will be your Max

 

[naungsai]

Dear Mailman

Thanks. It works fabulously.

Wishing you happy new year.