>Thank you for your suggestions, I couldn't group by Student name because some students had the same name but I could group by their Student ID which is unique and I was able to get the results I needed. Once again thanks for the suggestion because I was always a little shaky when it came to the difference between order by and group by.
>
>Mark A. Struck
Glad it worked. I should have thought of the name identities. My 'shakiness' is WHERE and HAVING.
Barbara