report creating a fake duplicate

The query from which the report is created has no duplicates. But the last
record in each group is duplicating itself. I need any direction to removing
this.

NB: the report has grouped records appearing in 8 rows per group. The error
only occures when the group has 7 records.

This is one of those questions that baffle most of us because reports just
don't do this without some help from the designer. You must learn how to
trouble-shoot. For instance:
1) add a text box to the detail section with a control source of =1 and
runing sum set to Over Group. See what this produces...
2) color your detail section background YELLLOW and run the report. Is the
8th line yellow?
3) Look for code in the report
4) create a brand new report and test it with the same record source.
--
Duane Hookom
Microsoft Access MVP


"elaine" wrote:

The query from which the report is created has no duplicates. But the last
record in each group is duplicating itself. I need any direction to removing
this.

NB: the report has grouped records appearing in 8 rows per group. The error
only occures when the group has 7 records.

elaine wrote:

The query from which the report is created has no duplicates. But the last
record in each group is duplicating itself. I need any direction to removing
this.

NB: the report has grouped records appearing in 8 rows per group. The error
only occures when the group has 7 records.


Neither records nor reports "duplicate" a record. You must
be doing something to force the last record to be displayed
twice.

--
Marsh
MVP [MS Access]