Sorting on three headers and no dups

[Leventcos21]

Hi,

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.

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 the same for each employee.

Example
Dec. 2005
John Doe
record 1
record 2
record 5

Mary Doe
Record 3
Record 4
Record 5

I don't need record 5 to show for Mary Doe, how can I do this? Thank you

 

[jjb373]

Leventcos21 -

You mention you are running the report from a form that also has a subform. Are you pulling the data directly from that form or are you pulling your data from a query?

If you are pulling the data from a query...you may be able to change the unique values to yes in the properties for that query.

This is one of the first thoughts that came to mind.



Cheers,

JJB373