Report Displaying Multiple Duplicate Records due to Subform

[dearlandlord88]

[SOLVED] Report Displaying Multiple Duplicate Records due to Subform

Hello all,

I currently have a report which contains a subform. The master/child fields used to link them are called 'StudentID'.

In the table on which the subform is based, it is possible for multiple records to be associated with a single StudentID: in this case, the subform shows the locations where a student is studying, therefore if a student is based in three different locations the subform will display all three.

This seems to be resulting, when I run the master report, in three identical iterations of the same report being displayed (at least this is the only reason i can see why these duplicates would be displayed; it doesn't happen if a student only has one record in the subform).

Clearly, as a single instance of the report shows all three records in the subform anyway, I don't want to be seeing these duplicates.

Wondering if anyone has encountered anything similar before and could point me in the right direction?

Many thanks in advance.

 

[RainLover]

To point you in the right direct I can only give a part answer as I do not have what you have in front of me. The problem lies in the setup of the report. I assume Report cause you have used both Form and report in your question. The Report can be setup by clicking (in design mode) the dividers. Maybe it is a right click. There you will be given options like, Keep together, Force new Page or Repeat. There are a lot more options depending where you click. Don't forget there is also one in the Header menu or Ribbon. This is an annoying task. You just have to try the various options. Hope this helps some.

 

[dearlandlord88]

Hi Rain,

Thanks for this - it's definitely a report, but with a subform within it.

I don't think it's a problem with page division, the issue is that wherever there are multiple records in the subform, Access will show the master report a corresponding number of times. I want it to only show the report once, regardless of how many records appear in the subform.

 

[RainLover]

Hi Rain,

Thanks for this - it's definitely a report, but with a subform within it.

I don't think it's a problem with page division, the issue is that wherever there are multiple records in the subform, Access will show the master report a corresponding number of times. I want it to only show the report once, regardless of how many records appear in the subform.

This being the case I would say that the problem lies as I stated in my previous Post. The Top of the Report is a Report with the sub being a sub Report not a sub form.

 

[dearlandlord88]

Have now solved this.

In case anyone else ever comes across this with a similar problem, the issue was that the query on which the master report was based for some reason contained the table on which the subreport was also based.

Even though no fields from this table were selected in the grid, its presence among the relationships in the query still seemed to be causing the report to show multiple iterations.

Removed that table from the relationships in the underlying query and the duplicate iterations of the report disappear.

Rainlover, thanks also for your suggestions.

 

[RainLover]

I don't fully understand as I do not have the query or report in front of me. It works for you plus you have learnt something new. This is good. Good luck with the project.

 

[SalvaHH]

Hi dearlandlord88 thank you very much for your answer. It helped me solve my problem!