MatchSimilarAddress
(Updated On 07-Mar-2010)
Explanatory Notes
This sample db demonstrates matching of similar addresses resulting from
inconsistent data entry. For example, the following items might relate to the same
address (and are therefore required to be identified as similar) -
(Address Field) (Zip Field)
2001 S. STATE ST. 84190
2001 S. STATE ST. S 84190
2001 SOUTH STATE ST 84190
The demo form in sample db performs dual role, both for data entry as well as for
identifying similar addresses.
Similar addresses, covering sets of records pertaining to the same basic address, are
grouped together and such clusters of duplicate addresses are highlighted in alternate colors.
Version: Access 2000 File Format
Reference: DAO 3.6