Duplicate Records in a report

  • Thread starter Thread starter Krista P
  • Start date Start date
K

Krista P

I have a report based on a Query (made from two other queries). When I print
the report some of the records from the query are duplicated in the report,
but when I view the query they are not duplicated in the query. (Query has
101 records, but there are 130 records in the report).
 
I would try place a text box in the report header section with a control
source of:
=Count(*)
See if this value matches the number of records in your query.
 
Knowing the number of records won't solve the problem. I can see the
duplicates in the report, but I can't determine why Access is duplicating the
records in the report when they are not duplicated in the query results.
 
I don't need to know the count of records - I don't understand why my records
are duplicating in the report when they are not duplicated in the query from
which the report is based. Is there a way to create a control that says to
only show data one time?
 
I have never heard of a report duplicating or creating records that are not
in the report's record source. There could be code in your report that delays
moving to the next record so it repeats or controls repeated in both a group
header and detail section. There could also be code running in the On Open
event that changes the Record Source, filter, or other properties of the
report.

Have you checked for code running in the report? Have you tried applying
different backgrounds to different sections of the report? Have you tried
what I asked previously regarding the text box in the Report Header section?
 
Back
Top