count unique values associaed with unique name

[Corvida]

I've created a database of (among other fields) student names and classes. I have a relationship so that I can count unique instances of student names (they can be in the database more than once). I now need to be able to count the number of each class (2010, 2011, 2012, 2013) associated with the student to see how many unique students from each class was seen.

I'm using:

DupName=If(CounselorsStatsMatch::SerialNumber = SerialNumber;1;0)

FirstValue=If(DupName = 1; student name;"")

SerialNumber - auto enter

QtySum = Sum(CounselorsStatsMatch::Qty)

TotalUniqueStudents = Sum ( UniqueStudents )

Let me know if you need any more info.

Thanks so much!

[efen]

The structure of this database does not seem to be correct if there is more than one instance of the same student in the same table.