report generates duplicate entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Arri said:
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?
Click to expand...


It sounds like the main report's record source query include
the data from the subreport's table.
 
Yes. What's wrong with that? How do I fix it?

Marshall Barton said:
It sounds like the main report's record source query include
the data from the subreport's table.
Click to expand...
 
Back
Top