print one label multiple times on one sheet in access

[Guest]

Hi,
I need to print one address 30 times on one sheet of label. I have set the
report to start from the form & pick up the information from the form. It
prints one label correctly.
I now need to repeat the same information 29 more times on the same sheet.
Please help & thanks

 

[Rick B]

Just put the same fields on your report sheet thirty times.

Fill the sheet with the fields you want.

 

[Allen Browne]

1. Create another table with just one field:
CountID Number
Mark the field as primary key.
Save the table with the name "tblCount".

2. Enter 30 rows into this table, i.e. values 1 to 30.

3. Create a query that contains your original table, and tblCount. In query
design view, make sure there is *no* line joining the 2 tables. The lack of
any join causes the records to repeat 30 times, because of the 30 records in
tblCount.

4. Open your report in design view. Change its RecorSource property to this
table. Save.

You will now find that your label prints 30 times.

For more detailed information, see:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html

 

[Tim Ferguson]

I need to print one address 30 times on one sheet of label.

Use Word -- there's a wizard that will do this in seconds...


Tim F