Reports for labels

[pompeyjim]

I want to print the names and addresses for different companies onto lables.
I have several different reports to do this. One prints the names and
addresses for all the companies in the DB and one prints the name and address
for just one company. The problem is that the report for printing just one
company name and address will only print one label at a time. I need it to
print the name and address on all of the labels on the page. Is this possible
and if so how do I do it?

 

[Allen Browne]

If you have 16 labels to a page, create a table with just one field, of type
Number. Mark it as primary key. Enter records for 1 to 16.

Now create a query that uses both your Companies table and the counting
table just created. If you see any line joining the 2 tables in the upper
pane, delete the line. This will give you 16 copies of each label.

Drag the fields you want into the output grid of the query, and add the
criteria so it is limited to just the company you want. Save the query, and
use it as the RecordSource for your label report.