Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    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!

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Base the report on a query which looks something like
    SELECT studentID, firstName, lastName
    FROM   students
    SELECT studentID, firstName, lastName
    FROM   students
    WHERE  duplicateReport = "Y"
    ORDER BY studentID
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts