Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-28-2015, 11:06 PM   #1
Newly Registered User
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
DennisDown is on a distinguished road
Unhappy Report repeats 35 times

I have designed a simple database to manage the publication of a weekly list of events. One report I have designed has two (2) sub-reports and prints in 2 columns on one A3 page - This week's events and featured future events. I have used a parameter form to set the date ranges for both sub-reports. When I run the report, it shows up 35 times.
I have another very similar report using exactly the same queries and parameter form but printing on A4 paper. It is made up of a base report and a sub-report and it prints once and usually stretches to 2 pages. I could not get the A3 report to print on one page when I tried the base report and one sub-report so went to 2 sub-reports to get it to work. It works fine but shows up 35 pages. I am just printing page 1 and everything is good but it is very annoying. Any ideas on where I should start looking for the problem.

DennisDown is offline   Reply With Quote

report duplication , reports , sub reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report detail repeats records mbryant Reports 10 04-23-2015 12:47 PM
Report Repeats Detail Information holmes213 Reports 1 05-06-2011 04:31 AM
Advanced query + report that sorts according to repeats tareksul Reports 7 12-20-2010 02:31 PM
Sum without repeats nikhatter Queries 4 06-06-2008 12:23 PM
Data in sub-report copied several times in main Report fred05 Reports 3 07-19-2005 12:06 AM

All times are GMT -8. The time now is 03:21 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World