Printing reports

  • Thread starter Thread starter Marta Rosa
  • Start date Start date
M

Marta Rosa

Hello,

My problem is:

I have a table with 5 records. I have a label report. My
label sheet has 16 labels in one page.

What I wanna do is repeat each record of my table so it
prints 16 times. Which in the end I will have 3 label
sheets, each one with one record times 16 times.

Did I make myself clear ? Please help me. Thank you
 
Marta Rosa said:
Hello,

My problem is:

I have a table with 5 records. I have a label report. My
label sheet has 16 labels in one page.

What I wanna do is repeat each record of my table so it
prints 16 times. Which in the end I will have 3 label
sheets, each one with one record times 16 times.

Did I make myself clear ? Please help me. Thank you
Click to expand...

Create a small dummy table with a single numeric field 16 records in it (numbered
1-16). Add this table to your query and DO NOT create a join line to your existing
table. This will cause all records in the table to be repeated 16 times.

The only reason to make the field numeric is if you ever need to add flexibility.
You can add more rows if you need more copies and you can use criteria against the
numeric field if you need fewer copies. For example; if you used a criteria of <11
on the number field you would only get 10 copies of each record instead of 16.
 
Back
Top