Report giving duplicate subreports

[kaychele]

Hello Everyone,

I am not quite new to access but am venturing out more! Exciting for me!

In my database, I have a report called "rptEventsbyEmployee" and in that a subreport called "sbrptEventsbyEmployee". The master/child link is the employee name. Everything is fine until you get to page 3 where the subreport shows twice. Can you tell me how to fix this?

Thanks so much!

 

[JHB]

Do you only want to show the subreport one time at each page, or what is the problem, (a printscreen could help understanding your problem)?

 

[kaychele]

Hello JHB,

Thanks for helping. I have attached the pdf of the report. On the first page, the participant "Leigh Ann" is only involved in one activity and so the subreport shows only once; on the second page, the participant "Test Test" is in three activities, so the subreport shows up three times with the same information. How can I change it so the subreport only shows up once on "Test Test"?

Thanks!!!

 

[JHB]

If you've link the main and sub report correct using the Link Master-/Link Child fields, which I think you have, then the record source for the main report is wrong setup, try to add the Distinct keyword after the Select keyword, so that the the participant only appear once.

Select Distinct .....

 

[kaychele]

I'm sorry, I am confused. Can you tell me how to do this?

 

[JHB]

Is the record source for the main report based on a query or table?
If table, then change it to a query in which you've the Select Distinct!
Here is a link to "Use a query as the record source for a form or report"
https://support.office.com/en-in/ar...a7d-8e77-e498966cd41b?ui=en-US&rs=en-IN&ad=IN
Here is a link to "Select Distinct"
http://www.fmsinc.com/microsoftaccess/query/distinct_vs_distinctrow/unique_values_records.asp
Else post your database with some sample data, (zip it because you haven't post 10 post yet).