print the survey sheets for the number of student enrolled in a class for all classes

  • Thread starter Thread starter sa sa
  • Start date Start date
S

sa sa

I need you help. I am trying create very simple hardcopy survey print
database. But i got stuck on the area where i need to print number of
copies of the report based upon the value on the field.

Basically, I am trying to print the survey sheets for the number of
student enrolled in a class for all clases. Class A with 10 student
enrolled, print 10 copies of the survey, class B with 5 student, print
5 copies of the survey. I need to include teacher and class
information at the top of the report so i can track surveys.

EX:
CrsCode Title Teacher Enrollmnt
CS Computer Sci Mr. Smith 5
BIO Biology Ms. Smith 2
EDU Education Mr/Ms Smith 3

So print all survey would print 5 copies of survey with CS title and
teacher name at the top and proceed to next.

I can print a record with following code but how do i print all?
Docmd.printout , , , , Enrollmnt

thanks
 
One method used to print more than one copy of a report is to create a table
of numbers with a single numeric field and values 1 - whatever
tblNumbers
Num 1, 2, 3, 4, ....
Add this table to your report's record source and place the Num field in the
query grid. Set the criteria under the [Num] field to
<=[The value on the field]
 
Back
Top