Printing multiple labels

[gabowers]

I am trying to print multiple labels from a query. For sum I may want 3
others 4. I want to be able to enter an item number (this is an autonumber in
a table) and the number of labels I want then move to the next item number
etc.

Now I can only do one number at a time and then re feed the sheet thru the
printer. After a few times thru the sheet gets messy.

 

[Duane Hookom]

Can you add a quantity field to your item table? Or, create a "table to
print" with the Item Number and Quantity fields? Then create a table of
numbers with a numeric field (tblNums.Num) and add numbers 1 through 999999
(or less depending on your maximum qty).

Add the table tblNums to your report's record source with your other tables.
Set the criteria under the Num field of tblNums to <=[Quantity Field].

This should create multiple records for each item depending on the quantity
values.