I have a training database (5.0) for classes taken. Each time a person takes a class they are entered in the database. I have created a report layout to summarize the data. The layout uses the Student number as a breakfield. I need to count each student only once even though their name may exist several times in the database (my summary field counts all the entries for each person). Is there a way to count each one only one time? Thank you for your help with this.

Yes! Define a self relationship with Student Number matching Student Number. Create a calculated field:

Mark (calculation) =

Student Number = Max(SelfRelation::Student Number)

This will set Mark for a record, if the record number is the highest numbered record for a given student number. It is only set once per student. You can total the Mark fields to give you the number of students. You can't use this function to mark records for display in a portal in another file as the Mark field can't be indexed. -bd

[This message has been edited by LiveOak (edited October 05, 2000).]