MS Access VBA Code
$30-185 USD
Paid on delivery
**RAPID TURNAROUND REQUIRED! WE NEED TO GO LIVE WITH THIS MS ACCESS ROUTINE TODAY!**
We are processing mailing lists from multiple different sources using Microsoft Access. As a part of this process, we must match records together that are from the same business location. We match records by creating a MatchKey. For example, for the following record:
ABC Company
123 Main Street
Anytown, VA, 22111
We may create a MatchKey that combines the zip code and company name (22111ABC). Because of the poor quality of the data, we are having to create multiple MatchKeys. So, for example, our first MatchKey for the above record may be 22111ABC, and our second may be 221123MAIN (combining zip code and street address).
Ultimately, we may have 2, 3 or more matchkeys. We have no problem creating the matchkeys ourselves. But we need an algorithm to bring ALL the matchkeys together to create a single "Master Key."
The attached .mdb file contains an example of what our table would look like before and after the "Master Key" process runs. In addition, it includes a subroutine (in Module1) that contains specific requirements for the subroutine we need developed.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) An MS Access module, delivered as part of an MDB database in ready-to-run condition.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
MS Access XP
Win XP Pro
Project ID: #3398516