repeating records in a subreport

I've got a subreport that repeats itself as many times as there are records
in the subreport. For example, if there are six records in the subreport
recordset, those six records will be displayed six times in the same
subreport. However, the problem isn't in the underlying query, becuse those
records aren't repeated in the query datasheet. So it would seem the
problem is somewhere in the report.

I'll mention that that "problem" subreport also has a nested subreport
within it, but I don't think that subreport is part of the problem, becuase
when I display the subreport by itself, none of the records in it are
repeated.

I'm at a loss. Can anyone tell me how I can keep this report from
displaying the records multiple times?

Thanks in advance,

Paul

You are probably including a level of detail in the main report that
duplicates the level of detail in a subreport. For instance a main report of
the Orders table should not include OrderDetails since the OrderDetails
should be in the subreport.

--
Duane Hookom
MS Access MVP
--

"Paul James" wrote in message
...
I've got a subreport that repeats itself as many times as there are
records
in the subreport. For example, if there are six records in the subreport
recordset, those six records will be displayed six times in the same
subreport. However, the problem isn't in the underlying query, becuse
those
records aren't repeated in the query datasheet. So it would seem the
problem is somewhere in the report.

I'll mention that that "problem" subreport also has a nested subreport
within it, but I don't think that subreport is part of the problem,
becuase
when I display the subreport by itself, none of the records in it are
repeated.

I'm at a loss. Can anyone tell me how I can keep this report from
displaying the records multiple times?

Thanks in advance,

Paul

You're exactly right, Duane, I had a field in the main report that was
duplicating a field in the subreport.

Thanks for explaining this.

Paul