Mailing Labels (Printing multiple copies of same record)

[OldCityCat]

After using the Label Wizard to create my label, I run my query to select a single record to print, When I do a print preview I only see that one record.
If I modify me query to return all records then all records show in print preview.


So what is the trick for printing say 20 copies of a single record?

Thanks in advance for any and all suggestions
OldCityCat

[June7]

Solution I use is VBA procedure to copy duplicate records to a temp table. I can produce up to 24 little labels of the same record on one page. The report is setup for columnar output.

Method in this article looks promising, I will have to explore http://support.microsoft.com/kb/207664

Otherwise, print 20 copies of the report.

[OldCityCat]

I'll play with your VBA option.

But why should we have to do a work around for such a common process, you'd think it would be built into Access.

Otherwise, print 20 copies of the report.

I tried that but only one record per page
How do you get more the one record on a page when printing copies?

[June7]

Need work around because Access is not a word processor, it is a data management tool and it manipulates records.

You won't, you are printing the same report 20 times, not one report with 20 records. I know, bad option but I'm not holding anything back, I give, you pick.

Another option might be a label printer. I've never worked with any and don't know how well Access interacts with them.

UPDATE: tried the code method from link in post 2 - works great!