Duplicate Paramters

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I am using Access 2002. I have a report that is grouped by txtCourseTitle
and the information is in the group footer. I have another report that I
want to show up on this report so I dragged it into the same group footer.
Each of these reports has their own parameters to enter for Year and Quarter.
When I run the report the first reports parameters run, I enter both of
them, then the report that was dragged into the group footers' parameters
run. The problem is they run twice. Can anyone tell me why and know how I
can fix it to not do that. If the report is run outside of the report it was
dragged to the parameters only come up once. Thanks in advance.
 
Ann said:
I am using Access 2002. I have a report that is grouped by txtCourseTitle
and the information is in the group footer. I have another report that I
want to show up on this report so I dragged it into the same group footer.
Each of these reports has their own parameters to enter for Year and Quarter.
When I run the report the first reports parameters run, I enter both of
them, then the report that was dragged into the group footers' parameters
run. The problem is they run twice. Can anyone tell me why and know how I
can fix it to not do that. If the report is run outside of the report it was
dragged to the parameters only come up once.
Click to expand...


If the subreport in the group footer is limited to the same
year and quarter as the main report, then just add the year
and quarter fields to the subreport control's
LinkMaster/Child properties and leave the parameters out of
the subreport's record source query.
 
Back
Top