How to replicate a number a specified amount of times?

[laxster]

Hi,

I have built a tool which allows for people to create multiple placards for shipping. All placards have the same information on them, except for the quantity. Each placard represents a record, and is deleted once the placard is printed.

The critical piece is that the records are duplicated a certain number of times. If a branch/plant location would like to print 20 placards, the report should then print 20 pages (1 of 20, 2 of 20, 3 of 20, etc). While I do have the rest built, I can't quite find a way implement a way to intentionally duplicate the records the specified number of times,

Any ideas?

 

[DCrake]

Create a table of numbers and add this table to a query but do not join this table. Then bring down the number field from the numbers table and enter <=20 in the condition field this will then create 20 records for the same customer.

 

[laxster]

Well, it needs to be controlled off of a form where. 20 was an example, but if they enter 4, 15, 52, etc. it needs to print off that many automatically. How would I be able to accomplish that?

 

[DCrake]

Use form references or global variables and functions from withing the query.

 

[laxster]

Thank you; that worked perfectly!