Support 805.461.7300
Sales
Our Technology. Your Success.

Merge Data from Duplicate Records into 1 record and 1 Field

This command will combine information from up to 3 different fields and 30 duplicate records into one record.
  • Download the command file to your system.
  • Extract the “Merge Dup Information Into A Single Field 30 Max.txt” into the AccuZIP6 5.0\Commands Folder.
  • Extract the “merge_dup_any30.FXP” directly into the AccuZIP6 5.0 folder.
  • Open the database that you would like to run the command on.
  • Run the duplicate search as normal, MAKE SURE TO SELECT “Backup Duplicates” in that screen.
  • Run the command from the Edit|Command option. This command will combine up to 30 matching records into one field.
  • In the command you can combine up to 3 fields, simply list the fields in the command.
Example:
**1st Field**
COM_FIELD="FIRST"
=MERGE_DUP_ANY30()
**1st Field**

« Back to Commands

We have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.
M.S., Mt. Vernon, IL