Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print # of labels based on a quantity field

How To

Print # of labels based on a quantity field

by  CosmoKramer  Posted    (Edited  )
This is a very simple process that works well!

Add a table to your database that only has one number field. Populate this table to contain sequential numbers 1 to whatever the maximum number of labels you might print.

Add this table to the query that is the record source for your label report. Don't join it.
Add the field that contains the numbers to the query grid and set the criteria for this field to:

Between 1 And [YourQtyField]

This will generate the [YourQtyField] number of labels for each item........
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top