A page full of labels of the same address

[John Baker]

I have created an Avery label form based on a query which only returns one
record. This works well and gives me what I want.

However I would also like a page full of labels, all based on the one record
the query returns. That is a page full of labels, all of the same name and
address.

Can anyone suggest how to do this?

Any help greatly appreciated.

John Baker
(e-mail address removed)

 

[Allen Browne]

If you need 16 of the same label, create a table containing 16 rows (e.g.
numbered 1 to 16).

Create a query containing this table and the one that has the address
details. If you see any line joining the 2 tables in the query, delete it.

Make this query the RecordSource for your report.

For an explanation of how it works, and how to extend it to other uses, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Allen Browne]

Please note that approaches the use the Format and Print events of the
report sections are not reliable for printing only some pages of a
multi-page report. Because the events do not fire for the pages that were
not printed, the results can be unpredictable and incorrect.

If you are only printing a single page, it will work fine.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Here are two ways which not only prints any amount of
labels but also lets you skip the labels already used.

Method 1

See article:
Skip Used Mailing Labels and Print Duplicates in Access 2000
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231801&Product=acc2000
[snip]