Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users
Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince
- Posts: 1910
- Joined: Tue Sep 19, 2006 3:29 pm
If you have multiple records with the same address but different names in your database, this command and the small program that you can download will combine the names that share the same address into one record, and it will remove the duplicate addresses from the database.
Make sure you have the field "LAST" in the database and the names are parsed, the command bases the match on Address+last.
Download the family5.zip file
and unzip it into your C:\Program Files\AccuZIP6 5.0
Pull down the Edit menu to Command, and run this two-word Command:
After running the command, the duplicates will be removed with one instance of each address kept, and the names that were in each duplicate will be added to the original record.