Printing x copies of report based on x available seats

[Guest]

I created a database for a summer conference that my office is putting on.
What I am in charge of is printing out "tickets" for courses that have
available seats. I have created a report in Access that creates the tickets,
but I do not know how to make it print "x" number of tickets based on the
number of availalbe seats. For example, course number CURR-0101-06-001 has
14 available seats, so I would like to have 14 tickets printed.
CURR-0123-06-003 has 1 available seat, so I would like only 1 ticket printed.
If this doesn't make sense, let me know

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

It explains how to create a query will generate the right number of records
for the report.

 

[Guest]

Thank you so much! It worked like a charm!

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

It explains how to create a query will generate the right number of records
for the report.