D
Dave M
I have seen the messages around stating how if I have say 10 records and I
want them to be printed 5 times each then I can create a table "numbers" and
add the "num" field to the query and it will print X times. X is based on how
many records are in the numbers table.
I have a similar question except I want to be able to change the X for each
record.
E.g - 10 records with a field QTY. I need to be able to print each record X
number of times based on the QTY. So record 1 might have 10 repeats, record 2
might have 150 repeats and randomly so on.
I was thinking I might have to make a temporary table that I populate each
time I run the report as it is always a different report. E.g append the
record into a temp table and use a for next command to tell it how many times
I need to do it based on the qty field.
If anyone else has a better idea it would be appreciated.
want them to be printed 5 times each then I can create a table "numbers" and
add the "num" field to the query and it will print X times. X is based on how
many records are in the numbers table.
I have a similar question except I want to be able to change the X for each
record.
E.g - 10 records with a field QTY. I need to be able to print each record X
number of times based on the QTY. So record 1 might have 10 repeats, record 2
might have 150 repeats and randomly so on.
I was thinking I might have to make a temporary table that I populate each
time I run the report as it is always a different report. E.g append the
record into a temp table and use a for next command to tell it how many times
I need to do it based on the qty field.
If anyone else has a better idea it would be appreciated.