Show Bid Request Access database help needed Bid Request Id: 52554 Bookmark in my 'To Do' list Posted by: rozsa2 (8 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 21.43% Buyer Security Verifications: Excellent Approved on: Mar 12, 2003 3:31:49 PM EDT Bidding Closes: Mar 15, 2003 2:58:07 PM EDT Viewed (by coders): 464 times Deadline: 3/20/2003 TIME EXPIRED Phase: 100% of work was accepted by buyer. Coder account has been credited. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, Access Enter chat room for this bid request (1 active users at Sep 1, 2003 8:55:39 AM EDT) Description: This work is for an Access database issue. I have a database in Access with 600,000 business names, addresses, phone numbers, email addresses, etc. My problem is there are several duplicates in the database that I need to pull out, and I am looking for an automated way to do this as much as possible. I do not want to go through all 600,000 records to find duplicates. Some examples of records are as follows: Smith Construction Co Smith Construction Co Inc Smith Constructoin Co Inc Smith Constr Co Inc John Smith Construction Co - All with similar addresses - Then there are instances such as: Smith Construction Co - 1234 Street Name, Dallas, TX A J Smith COnstruction Co - 5678 Street Name, Houston, TX A J Contruction Co - 1234 Street Name, Dallas, TX Smith Construction Co Inc - 8888 Street Name, New York, NY I need to have a Macro/Module written that can compare the records and update another field with an "X" if there is a good chance that record is a duplicate. That way I can go back through and filter out all the "X"'s to manually verify that they are indeed duplicates. NOTE: A FIND DUPLICATES QUERY WILL NOT WORK AS THE RECORDS ARE NOT EXACT DUPLICATES. I need something perhaps that checks character per character and calculates a frequency of similarity, which would make it appear to be a duplicate. If you need any more information, please let me know. I will attach a small sample of the database I am working with Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Platform: Access 97 preferably Must be 100% finished and received by buyer on: Mar 20, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! CaptainJoe (7 ratings) in Charlton,Oxon, UK OX17 3DG United Kingdom Bid id: 565,461   $20 (USD) Mar 13, 2003 8:29:56 AM EDT  9.85 (Excellent)     I can provide you with a query/function that can give you near matches with a weighting in bout 20 minutes from my bid being accepted. Interested ?           See 2 private reply(ies) to/from CaptainJoe.