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.
-- 
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP 
http://www.access.hookom.net/UCP/Default.htm


"Krista P" wrote:

> 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).

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.

"Duane Hookom" wrote:

> 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.
> -- 
> Duane Hookom
> Microsoft Access MVP
> If I have helped you, please help me by donating to UCP 
> http://www.access.hookom.net/UCP/Default.htm
> 
> 
> "Krista P" wrote:
> 
> > 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 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?

"Krista P" wrote:

> 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 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?

-- 
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP 
http://www.access.hookom.net/UCP/Default.htm


"Krista P" wrote:

> 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.
> 
> "Duane Hookom" wrote:
> 
> > 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.
> > -- 
> > Duane Hookom
> > Microsoft Access MVP
> > If I have helped you, please help me by donating to UCP 
> > http://www.access.hookom.net/UCP/Default.htm
> > 
> > 
> > "Krista P" wrote:
> > 
> > > 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).