Hi everybody. I need your expertise to answer me this. It could probably be very easy, but have no clue how to do it.

This is the problem: I will try to explain it. I have a recordset which has the records of all the pupils "enrolled" to some curse (e.g. "Mathematics") However, this pupils could appear repeated. For example if he was "erased" because of several absences to the curse (or different causes) and "re-enrolled" later with a justification for his absences. (never mind this... just to catch the idea). The real problem is how do you have to write the SELECT statement to be able to get the list of the pupils still who are still enrolled. I have a field with the date of each new record, so I would need to get the "newest record" for each pupil in the curse. Got the point??

P.S.: Just in case, I'm using SQL Server 7 and VB 5