Command to Merge X Data into 1 Record

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

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Command to Merge X Data into 1 Record

Post by Kristen » Wed Nov 21, 2007 3:49 pm

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\AccuZIP6 4.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

Post Reply