Repeating Data in a Report

L

lovespar

I have a report with 8 pages of actual data, but it is repeating 61 times for
a total of 488 pages . I have set the query the report is base on to Unique
Values= Yes and that didn't change anything, I tried setting it to Unique
Records =Yes and that didn't change anything. I don't have any blank pages,
just repeats.
Any ideas out there?
 
D

Douglas J. Steele

So the query repeats the data 61 times? How is the query constructed? Is
there some table being included in the join that has 61 entries, and the
appropriate criteria hasn't been specified for the join?
 
S

storrboy

I have a report with 8 pages of actual data, but it is repeating 61 times for
a total of 488 pages . I have set the query the report is base on to Unique
Values= Yes and that didn't change anything, I tried setting it to Unique
Records =Yes and that didn't change anything. I don't have any blank pages,
just repeats.
Any ideas out there?
Click to expand...


In my experience, when data repeats itself, it quite often has to do
with joins in the query. Perhaps you are using the wrong kind, or none
at all? ie. Equal or Inner Join where a Left should be used?
 
Top