Labels

[Guy Lydig]

I have a table with names of students in 3 different grades with 8 or 9
classes per grade. (First Name, Last Name, Grade, Section)

I want to create labels for each student as follows:

For all students in grade 9, I need 8 labels per student
For all students in grade 10, I need 9 labels per student
For all students in grade 11, I need 7 labels per student

The label paper has 30 labels, 10 per each of 3 columns.
I can do one grade at a time but

1) How do I set up the labels so I have the required number of labels for
each student on the same sheet of label paper in one column and leave the
remainder of the column blank?

2) Can I get a change in class to automatically switch to a new sheet of
label paper?

3) If I decide to not waste the labels at the end of the column, can I set
it up so that I get the required number for each student, and then the next
student automatically continues in the next label for the required number?

I hope this is clear.

Thanks

Guy

 

[Duane Hookom]

You can create a table of numbers [tblNums] with a single numeric field
[Num]. Add numbers 1-10 (or more). Create a table of Grades with a Quantity
field. Add records:
Grade Quantity
9 8
10 9
11 7

Add both of these tables to your report's record source and join the Grade
fields. Add the Quantity field to the query grid and set its criteria to:
<=Num
This will create a recordsource of the appropriate number of copies.