ACC2000: Sample Query to Print One Label for Two People at the Same Address (207753)
The information in this article applies to:
This article was previously published under Q207753 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
When you have a list of names for which you would like to generate mailing
labels, there are frequently two people listed at the same address. This
article demonstrates a technique to create a query from which to print a
single mailing label for two people at the same address.
NOTE: If more than two people on your mailing list live at the same
address, only the names from the first and last record with that address in
your table appear in the query.
REFERENCESFor more information about using the Label Wizard, click Microsoft Access Help on the Help menu, type create mailing and other types of labels in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbhowto kbinfo kbprint KB207753 |
---|
|