adres labels

  • Thread starter Thread starter Gunter Hemeleers
  • Start date Start date
G

Gunter Hemeleers

i want to print adres labels from the same adres . Now i can print labels on
a page from my record and each label is different but i want to print a page
with all the same labels .
 
Create a table with just one field named (say) CountID, type Number.
Mark it as primary key
Save the table with the name tblCount
Enter a record for each label on your page. For example, if your page fits
12 labels, enter the numbers 1 to 12.

Create a query that contains the table that has your address, and also
tblCount. There must be no line joining the 2 tables in the upper pane of
the query design window. This query will give you 12 copies of each label.
You can use criteria to limit it to just one address if you wish.

You can use this idea in other contexts also. There's an example and more
detail in this article:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
 
I find the easiest method is to create a table of numbers [tblNums] with a
single numeric field [Num]. Add values to this table 1,2,3,... so you have
at least enough numbers as you need duplicated labels. Then add this table
to your report's record source and don't join any tables to it. Add the
[Num] field to the grid and set its criteria to
<=30
This assumes you want 30 of the same label. Your report should now display
and print 30 of each label.
 
Back
Top