This may be a common question and I have looked around but with no avail.

I am running a report from a form that has a subform, too.

These are the 3 sorts that I am doing on the report
1.The sort is by Date (Month)
2.Then I am sorting by the names of the subform (usually 1, 2, or 3 names)
3. Then I am sorting by record number.

Everything works except if the subform has 2 or more names, it will duplicate a record number for each employee. I have tried to hide dups on the properties.

Dec. 2005
John Doe
record 1
record 2
record 5

Mary Doe
Record 3
Record 4
Record 5

I would like it to only show record 5 for John doe and not Mary Doe

Thank you,