I am running a report which has a similar field break down as in the information listed below. I was wondering if there is a way to list all the schools and the just the first student of each?
Let us a assume the each student is a member of one school for normalization purposes.
Happy school June
Fun School Harry
Sad School Debra