Access database help needed

Fertiggestellt Veröffentlicht Mar 12, 2003 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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

Ingenieurwesen Microsoft Access MySQL PHP Softwarearchitektur Testen von Software

Projekt-ID: #2915469

Über das Projekt

21 Vorschläge Remote Projekt Aktiv Mar 13, 2003

Vergeben an:

captainjoe

See private message.

$17 USD in 14 Tagen
(13 Bewertungen)
3.4

21 Freelancer bieten im Durchschnitt $61 für diesen Job

gribfritz

See private message.

$17 USD in 14 Tagen
(484 Bewertungen)
7.6
sawamu

See private message.

$21.25 USD in 14 Tagen
(215 Bewertungen)
5.9
amsterdamd

See private message.

$55.25 USD in 14 Tagen
(99 Bewertungen)
5.8
DiegoCalp

See private message.

$8.5 USD in 14 Tagen
(51 Bewertungen)
5.6
deeeepblue

See private message.

$21.25 USD in 14 Tagen
(22 Bewertungen)
5.0
sissoftware

See private message.

$51 USD in 14 Tagen
(18 Bewertungen)
4.9
sabonzovw

See private message.

$42.5 USD in 14 Tagen
(26 Bewertungen)
5.3
thecodebuyer

See private message.

$59.5 USD in 14 Tagen
(24 Bewertungen)
4.6
pvavw

See private message.

$85 USD in 14 Tagen
(39 Bewertungen)
3.9
bzmind

See private message.

$84.15 USD in 14 Tagen
(7 Bewertungen)
3.3
friendlydevvw

See private message.

$25.5 USD in 14 Tagen
(11 Bewertungen)
3.0
simplycreativevw

See private message.

$42.5 USD in 14 Tagen
(7 Bewertungen)
3.0
garynewelluk

See private message.

$25.5 USD in 14 Tagen
(11 Bewertungen)
2.1
brianalex

See private message.

$21.25 USD in 14 Tagen
(11 Bewertungen)
1.6
mylesskehan

See private message.

$85 USD in 14 Tagen
(3 Bewertungen)
0.6
paddedbraincells

See private message.

$425 USD in 14 Tagen
(0 Bewertungen)
0.0
borismatkov

See private message.

$34 USD in 14 Tagen
(0 Bewertungen)
0.0
toolco

See private message.

$17 USD in 14 Tagen
(0 Bewertungen)
0.0
csproductionsvw

See private message.

$85 USD in 14 Tagen
(0 Bewertungen)
0.0
peanutsvw

See private message.

$51 USD in 14 Tagen
(0 Bewertungen)
0.0