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

I refer AccuZIP because of the customer service. You have a live person that answers phone calls and fields them to the correct person for help. On top of that each of your technicians knows their stuff! They are always helpful.
T.P., Spartanburg, SC