Microsoft KB Archive/100146

= ACC: Printing Duplicate Mailing Labels for Each Record (1.x/2.0) =

Article ID: 100146

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q100146



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
This article describes how to print multiple labels for each customer record. The example that follows uses the Customers table in the sample database NWIND.MDB.



MORE INFORMATION
The following example generates 10 labels for each customer record:

  In the sample database NWIND.MDB, create a new table called Label Count with one number field. Use the default properties and do not create a primary key. Enter a 1 in the first record, 2 for the second record, and so on.

     Table: Label Count --     FieldName: Count DataType: Number   Create a new query based on the Label Count and Customers tables:

     Query: LabelQuery -     Type: Select Query Tables: Label Count and Customers Join: None   From the View menu, choose Totals so that all fields are set to Group By, as follows:

     Field: Company Name Table: Customers Total: Group By     Field: Contact Name Table: Customers Total: Group By     Field: Address Table: Customers Total: Group By     Field: City Table: Customers Total: Group By     Field: Region Table: Customers Total: Group By     Field: Postal Code Table: Customers Total: Group By     Field: Count Table: Label Count Total: Group By        Criteria: <= [Enter Number of Labels to Print for Each Customer]

NOTE: The Count field in the Label Count table can have an optional parameter value specified in the Criteria field to enter the number of labels to print for each record in the Customers table. If this query is used without a parameter value, 10 identical labels are printed for each record in the Customers table.  Using the Microsoft Access ReportWizard, create a new mailing label report based on the LabelQuery query. If you specify a parameter value, you are prompted to enter the number of labels to print for each customer record.</ol>

<div class="references_section">