Page 1 of 1

Combine multiple people at the same address into 1 record

Posted: Thu Jun 09, 2011 8:08 am
by Eric
The following command will combine multiple people at the same address into one record. Instead of merging two or more people with the same name as “The Jones Family”, they will be listed by first name and separated with “and”, e.g., John and Mary Jones, and Bob Thomas vs. The Jones Family, and Bob Thomas.

Download the familyfriendsnamemergeand.zip file, then extract it into the C:\Program Files\AccuZIP6 5.0 folder.

With your database open in AccuZIP6, pull down the Edit menu to Command. Copy the command from the Code box below and paste it into the Command Statement Syntax area of the Command window:

Code: Select all

*To format First as Uppercase, enter 1 as the parameter

=FamilyFriendsNameMergeAnd(1)

*To format using PerfectCaps, leave parameter out or use 0

=FamilyFriendsNameMergeAnd()

This automatically creates a new database in the same folder as the original with “_new.dbf” as the ending, e.g., Demofile.dbf would result in Demofile_new.dbf.

The following field names must be present in the database:

First
Last
Address
Zip