Zillion Pages

[Guest]

I have a report based on a query and suddenly it is duplicating pages. When I
hit print preview - about 12 pages should come up and instead over 5,000 come
up and there is over 100 identical pages of each page. I have NO clue why
this started happening and can't seem to find any way to fix it??

Appreciate any help!!!! TIA

 

[Duane Hookom]

What have you looked at to begin your trouble-shooting? Have you checked to
see how many records are in your report's record source?

 

[Guest]

Hi, yes, the query that the report runs off of is returning over 5000 records
also, becuase it is duplicating them and I can't for the life of me figure
out how/why?? There are only 368 records TOTAL in this database right now
and only 12 of them should be reporting in this query/report?

 

[Duane Hookom]

It would really help if you provided us with the SQL view of your report's
record source. I expect you are missing a join line.

 

[Guest]

Ok, how do I provide that to you? (I'm pretty novice)
Thanks!!!

 

[Guest]

Something else that's weird. The report runs off of a query that is also
returning the same number of records, but when I went to sort the query
alphabetically so I could see if the records were exactly the same, all of
the extras disappeared and I was left with only the 12 I should've been left
with. But then I went and looked at the report and it's still showing over
5000.

 

[Guest]

To show the SQL view, you have to first open your report in design view. I
the corner of the report, where the two rulers (horizontal and vertical)
meet, you will see a box. Double click that box. In the box that comes up,
click the "Data" tab. On the data tab, copy everything you see in the box for
"Record Source." Be careful to get it all, but also be careful not to
accidentally type anything in that box. This will give those of us who can a
better chance to help you figure out your problem.

 

[Guest]

Ok, here is what is in the record source for the report Repurchase Report
(which is the query the report runs off of). I didn't see a way of doing the
same thing for the query?

 

[Duane Hookom]

Paul provided a great description of how to display the sql view of your
report's record source. Did you not understand how to copy and paste this
into an email or did you just send the email prematurely (been there and
done that)?

 

[Guest]

I think you forgot to paste it into your message. There was nothing there.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Guest]

I don't know what I did there??? I thought I copied it?? Anyway, I figured
it out, I hadn't linked the two tables in the query that the report runs off
of. Thank you both for your assistance though!!!!! (o:

 

[kansq]

Paul provided a great description of how to display the sql view of your
report's record source. Did you not understand how to copy and paste this
into an email or did you just send the email prematurely (been there and
done that)?