One Report Yielding Multiple Pages of Redundant Data

[JStrand]

I have a report using a union Query as a datasource. All the report data is contained in the detail section of the report. The data is appearing correctly on page 1, however there are several subsequent pages with the same data as page 1 and only excluding the report header.

It is strange that the number of pages 102 = the number of records in my union query. I have been testing the property settings on the text boxes and setting them all to hide duplicates but that is not solving the problem. Any ideas would be appreciated.

 

[MazeWorX]

its your query check the relationships

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[JStrand]

Thanks for the suggestion. I've been checking the source data which is a union query bringing together 2 crosstab queries all of which have the identical fields of course but their is not a duplicate record in the union query result nor in either of the crosstab query results. I'm thinking it has to be something in the report itself causing the duplication.

 

[dhookom]

Are there any sub reports?
Can you provide the record source of the main report?

Duane
Hook'D on Access
MS Access MVP