Repeat Count/Duplicate Records

[dmiller]

Good Morning.
I have a table with a field "quantity". The number in this field is
the number of times that I want to duplicate that record.
The "quantity" field can have a range from 1 to 20.
Currently I have been using a macro with a RunMacro action. In the
action arguements repeat count, I enter in the number from the quantity
field.
This runs a different macro that opens an append query.
The append query uses a text box in the form for the field criteria for
the quantity field.
Does anyone have suggestion on how I can to this faster.

 

[Allen Browne]

That's workable if you do really need that many records.

You could get Access to create the number of records on the fly (i.e.
without storing 20 different records) with a simple cartesian product query.
There is an example of how to do that to create a label for each entry in
this article:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[dmiller]

THANKS!
WORKS GREAT!

That's workable if you do really need that many records.

You could get Access to create the number of records on the fly (i.e.
without storing 20 different records) with a simple cartesian product query.
There is an example of how to do that to create a label for each entry in
this article:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html