I have created a report that shows the number of service days (i.e., difference between date received and date released) in ranges of "1 to 7 days", "8 to 14 days", etc...<br><br>I have supporting queries that:<br>1. calculate the differences between the dates entered<br>2. count the number of items falling into each range<br>3. calculate the overall average number of service days<br>and one that draws all of the above queries into one to support the report.<br><br>The calculations are all being performed correctly. The problem is that in Print Preview, and the printed output for that matter, I get as many pages of identical output as there are records in the table.<br><br>Everything I need is on the first page. How do I stop the duplicate results?<br><br>Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Duplicate Output in Print Preview
- Thread starter eskimo
- Start date
Similar threads
- Locked
- Question
- Locked
- Question