report generates duplicate entries

[Guest]

I am creating a report with TrainerNumber grouped with header and then
ClientNumber grouped no header and then a subreport for Service Hours.
Trainer information occurs in the group header; client information is in the
details. I am getting duplicates of clients if there are two entires in the
subreport; no duplicates if there is only 1 entry in the subreport. How do I
stop the duplicates?

 

[Marshall Barton]

I am creating a report with TrainerNumber grouped with header and then
ClientNumber grouped no header and then a subreport for Service Hours.
Trainer information occurs in the group header; client information is in the
details. I am getting duplicates of clients if there are two entires in the
subreport; no duplicates if there is only 1 entry in the subreport. How do I
stop the duplicates?

It sounds like the main report's record source query include
the data from the subreport's table.

 

[Guest]

Yes. What's wrong with that? How do I fix it?

It sounds like the main report's record source query include
the data from the subreport's table.

 

[Guest]

Please disregard my previous post. Your comment worked. Thanks.