Unanswered: Duplicating record in report/mail merge if value = Yes?
Some students at our school need duplicate academic reports sent home, so in our Students form (whose parent form is sourced from tblStudents, and which is linked to the subform, sourced from tblStudentGrades and linked via StudentID) we have a field Duplicate Report? (Yes/No)
What we would like to happen is that, when ticked Yes, a function would duplicate the records attributable to that student, when a report is run or a query is created. (Because we run our reports by class, it would be time consuming to individually print multiple copies of one report, which is why we are happy to just duplicate the records - but we would prefer not to duplicate them at table level, if you know what I mean).
I hope my question makes sense; if you have a solution or a better idea, I'd love to hear it. Thanks!