Printing labels in Access is really just printing a multi-column report. In
the Reports page of the database window select 'New' and then select 'label
wizard', and take it from there.
Tip: If you want to be able to print multiple copies of each label base the
label report on a query which includes the table containing the data for the
labels, e.g. a table of contacts, and another table LabelCounter say, with
one column LabelCount of integer number data type containing values from 1 to
whatever is the maximum number of each label you'd ever want to print. Don't
join the tables in the query. This will give you the 'Cartesian Product' of
the two tables (named after René Descartes). This joins every row of one
table to every row of the other. Include the LabelCount column in the query
and in its criteria row in query design view put a parameter such as
<=[Number of each label to print:]. Sort the label report first on an
appropriate column, e.g LastName and then on the LabelCount column if you
want each set of identical labels to print together. If you want them to
print in groups of distinct labels sort by a column such as LastName first,
then by the LabelCount column.
If you want the report to default to printing one of each label make the
parameter:
<=[Number of each label to print:] OR ([Number of each label to print:] IS
NULL AND [LabelCount] = 1)
Ken Sheridan
Stafford, England
