Report is perfect but . . .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report with information regarding Licensing Agreements,
which I have grouped by the License No. The first portion of the report just
has the details of that particular license.

I then have four different subreports based on queries for that particular
group, which include: termination/expiration details; royalty details;
expense details; and actions due details. When I created these subreports,
it asked me for a common field, which I selected the License No. field as in
the main report.

The report is perfectly formatted and shows exactly the information I want
in the way that I want it shown. The catch is that instead of only showing
one License No. with information for the four sections on the subreports for
only that License Number, it duplicates, triplicates, etc. the same License
No. with the same information in the subreports. How can I show only one
License No. with the subreports only one time.
S
 
It sounds like you have more detail information in your main report's record
source than needed. You should have only one record per License No in your
main report's record source.
 
--
S


Duane Hookom said:
It sounds like you have more detail information in your main report's record
source than needed. You should have only one record per License No in your
main report's record source.

--
Duane Hookom
MS Access MVP
--




You are a genius and my hero for the day!!!! Such little things can cause such major problems. In the original query for the main report, I was trying to do a query with all of the information for the entire report. When I was researching the discussion groups for questions, I came across one that discussed subreports which changed my enitre outlook. I then forgot to go back and delete the subreport information from my main query. Thanks and Happy Holidays!
Click to expand...
 
Back
Top