This command will merge the data in multiple fields from multiple records into one unique record:
......
1. Download and extract the file to your C:\Program Files (x86)\AccuZIP6 5.0\Commands folder.
2. Open your database.
3. Run the duplicate search (Make sure you select the option to “BACKUP DUPLICATES” at the bottom of the duplicate window”
4. After the duplicate search finds the duplicate records, updated the database by clicking the diskette in the upper left of the window.
5. Click OK and now you should have your duplicate records marked in grey.
6. Run the command “Merge X data” from the Edit>Command window
7. The command will combine all of the information from the various fields into the one record.
**For Example, this command will will combine the value X from the various fields listed below into those same fields in the one unique record. You can modify the field names in the command itself to reflect your field names.
****Fields in this command:
GOLDENCARE
VIP
MAJORDONOR
EMPLOYEE
CONSTRUCTI
TIMECAPSUL
The command will grey out the records that can be deleted.
To remove the deleted records pack the database from the Edit>Pack option
8. The command will grey out the records that can be deleted. To remove the deleted records pack the database from the Edit>Pack option
Command to Merge X Data into 1 Record
Moderators: Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Chrissy, Geoff, Vince