select a record X number of times

[k2tile]

How do I select a record X number of times?

This is for a printout of sticky labels to apply to products...X is the quantity of each product. If we need to label 100 of part A, then I need to select that record 100 times and feed it to my report.

Thanks

 

[Khushalay]

My problem is the same. To take print out x number of times to stick on the cartons. Any ideas please?

 

[Minty]

If the number varies per product I think you would need to run a totals query to get the number of records then per Product print the report that many times.
So the 2 below would print two copies , so assign it to a variable and set that to the number of products from your totals query.
DoCmd.PrintOut , , , , 2