Access Report printing Detail Section twice

I have a report in Access that is using a subreport. The subreport may have up to 15 items in it. For every item in the subreport the report is printing. So I have 15 items printing on my report with 15 items in each subreport. My query is selecting Distinct records. Is there a way to not print the Detail section of the first report more than once and still have the subreport print the correct amount of times?

As an example:

(Report)       Level: Chapter Title: Chapter 1
(SubReport)           Task: Spellcheck
                                Task: Get Proof Read ' the subreport only prints one task at a time, so this would be the subreport printing twice
(Report)       Level: Chapter Title: Chapter 1
(SubReport)           Task: Spellcheck
                                Task: Get Proof Read

I only want it to print the one time for the level and title, and still get every task to show up below.
Brandon GarnettAsked:
Who is Participating?
 
TONY TAYLORCommented:
You can attempt, but initially I think it has a join issue in a query.  That would duplicate data and it would possibly be embedded in the form (parent/child).
0
 
TONY TAYLORCommented:
Can you attached a sanitized copy of the database?
0
 
Brandon GarnettAuthor Commented:
I cannot but if you would like I can attach the code I am trying to run along with screenshots of the issue.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Brandon GarnettAuthor Commented:
This is the select statement I am using for both the form and subform.
SELECT DISTINCT BookDivisions.DivisionID, BookDivisions.Level, BookDivisions.BookNo, BookDivisions.ChapterNo, BookDivisions.SectionNo, BookDivisions.SubsectionNo, BookDivisions.SubSubsectionNo, BookDivisions.ParentID, BookDivisions.Title, BookDivisions.UpdateScope, BookDivisions.MostRecentPublishedResearch1 AS ['Primary Recent Research'], BookDivisions.RecentChapter1 AS ['Primary Chapter'], BookDivisions.MostRecentPublishedResearch1 AS ['secondary Recent Research'], BookDivisions.RecentChapter1 AS ['Secondary Chapter'], Div2Tasks.PrimaryEmployee, Div2Tasks.SecondaryEmployee, Div2Tasks.CompletionPercentage, Div2Tasks.ExpectedStartDate AS ['Expected Start'], Div2Tasks.ActualStartDate AS ['Actual Start'], Div2Tasks.ExpectedCompletionDate AS ['Expected End'], Div2Tasks.ActualCompletiondate AS ['Actual End'], Tasks.Task
FROM ((Div2Tasks LEFT JOIN BookDivisions ON Div2Tasks.DivisionID = BookDivisions.DivisionID) LEFT JOIN luBookLevel ON BookDivisions.Level = luBookLevel.BookLevel) LEFT JOIN Tasks ON Div2Tasks.TaskID = Tasks.TaskID
WHERE (((IIf([forms]![frmSelectReports]![cboPrimaryEmployee]>"",[Div2Tasks].[PrimaryEmployee]=[forms]![frmSelectReports]![cboPrimaryEmployee],""))<>False) AND ((IIf([forms]![frmSelectReports]![cboSecondEmployee]>"",[Div2Tasks].[PrimaryEmployee]=[forms]![frmSelectReports]![cboSecondEmployee],""))<>False));

Open in new window

This is the image of how the report prints
0
 
TONY TAYLORCommented:
I am not sure how to help you without looking at your report design and data.  If you could provide a sanitized version, I would likely be able to help you in quick order, but other than that, good luck.
0
 
Brandon GarnettAuthor Commented:
I've requested that this question be deleted for the following reason:

I solved my issue by redoing my SQL statement
0
 
TONY TAYLORCommented:
If "redoing my SQL statement" is the appropriate answer then rather than deleting the question and no credit being applied, I feel I should get credit based upon my answer in comment #40407078.

Just because I could not see the SQL, did not mean that I did not identify that it was not the leading cause of the issue and thus ultimately brought about the resolution to the question.
0
 
Brandon GarnettAuthor Commented:
It was an issue with the query
0
 
TONY TAYLORCommented:
Thank you.  I appreciate it!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.