One to Many Access Labels

[LNR]

I am creating student badges that show their name, student ID and then lists
their summer school classes. Since I have several classes for each student,
I have created a subreport so all of the students classes list under the
student's name. The problem I am having is 4 badges are printing for a
student if they have four classes, 3 badges if they have three classes (each
badge looks the same with the student name, ID and classes listed under the
name). How can I get 1 badge per student with all of the classes listed on
the badge? Thank you in advance.

 

[Paul Shapiro]

Your main report should have a record source something like:

Select ...
From Student as S
Where Exists (Select * From Enrollment as E Where E.studentID=S.studentID
And ... (whatever conditions you need to get the current student list for
whom you want badges printed).

The subreport record source would be something like:
Select ...
From Enrollment as E
Join Course as C On C.courseID = E.courseID ...

The link between the main and sub reports would be studentID.

Your current main form record source probably includes the enrollments as
well as the students. You could use that without any subreport by
establishing a group on studentID and putting the student name in the header
for that group. The enrollments would be in the detail section of the
report, rather than in a subreport.

 

[LNR]

If I am using the report label wizard to create the label, where/how am I
creating the select statement?