Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mailing Labels - I need one label for duplicate addresses!

Status
Not open for further replies.

Principal

IS-IT--Management
Oct 12, 2002
37
US
I have a database that has a number of duplicate addresses. I need a report that will produce one label for those duplicates. The name does not matter. It can be the first or last in the series. ANy help is apprecaited.
 
Create a query that Groups By the Address. This will return only one address for each set of addresses. To do this, add the address field to your query in design view then go to View...Totals on the Menu bar. Groupby the AddressField. Base your Report on this query.

Paul
 
Thanks Paul. I tried your suggestion. I was not able to run the query unless all the fields were "grouped by". If I understand you correctly only the one address field should be grouped by. WHen I attempt that I get a message about can run because my others fields are not aggregated. Thanks, Steve
 
Use group by for all of the fields you need for your labels (name, address, city, state, zip?). Don't use this query as a source for detailed data. A grouping query cannot return a field unless it is either part of the group by option or is a calculated field (ex: Sum, Count, First).
 
Hi!

Try creating your report using the label wizard and when it asks about sorting, sort on the address. Go into the design mode of the report and open the Grouping and Sorting box. Tell Access that you want a Group Header for the address. Now cut the text boxes out of the detail section and paste them into the Group Header section. Close the detail section all of the way down and set the header section so that it is a tall as one label. You should get a print out that you like.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Jeff:

Thanks for the suggestion. It worked beautifully. I most likley would not have thought of that. THanks again.
 
Hi!

Glad to help! As you know, solutions like these are the result of hours of headaches!

Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top