There are some functions to define the number of different copies for each record, ie to record 1, 100 copies are required to record 2, 200 copies are required.

If the number of copies is stated in each row of the database, i have a small script you can use, to create a new database where each row is repeated the stated number of times.

if you want it, i'll post it.

Luis,

If you click on a layout, you'll notice that the "Number of copies" field can contain a variable expression. This means that you could reference a field from your database that would contain the number of records, or use any kind of logical expressions to determine how many copies of a specific record.

Perhaps you could provide us with more information on the logic you intend to use to figure out the number of copies, so we can better help you to find a way to do it.

Regards,
Raphaël Lalonde Lefebvre

Hi Kennet,

If you can publish, we appreciate it.

Regards,

Luis

Hi Raphael,

the "Number of copies" does not work when you attach a database field.

As you would do?

Regards,

Luis

Hi Louis

I've tested Raphaels method with a VAL([databasefield]) as the expression - and it actually does work. Which renders my script a much more complex way of fixing it.

Luis,

I've tried it again just to be sure, and I confirm that it works fine.

As Kennet pointed out, however, you may need to use VAL if for some reasons it sees your field as text data rather than a number.

Can you perhaps give us more details on what happens when you say that it does not work? Is it a problem with your expression? Or it doesn't print the right number of copies?

Please provide more details.

Regards,
Raphaël Lalonde Lefebvre