Data Matching

[Guest]

Hi there,

I Have 2 tables, one is loans approved. The other is a list of name,
address' and other info supplied by Frauds dept. I need to be able to
identify possible matches between the frauds data and the approvals data, ie
identify those loans approved that have a possible match in the frauds data
working on the name.

I realise that this is open to a number of matches but it would still narrow
the number of matches that need to be investigated and would also give us
data to notify frauds, such as alias', etc.

Can someone help and point me in the right direction.

Thanks

 

[PC Datasheet]

Create a query that includes both tables. Join the tables on the common
field (CustomerID, Name, or whatever it is). The query will return all
records in both tables that share the common field.

 

[Guest]

Tanks for that now how can I refine it to return possible matches allowing
for variations on spelling, etc; Say customers name is Velkovski, yet in the
frads data it is spelt Velkovska J. How can I tweak the query to return these
possible matches??

 

[PC Datasheet]

The best you can do is create two queries; one for each table. Put the
following expression in an empty field:
LettersToMatch:Left([CustomerName],4)
Now create a third query that includes both the first two queries. Join the
two queries on LettersToMatch. You'll now get all records where the first
four letters of the customer name is in both tables.

Note: Change the 4 to whatever you think is appropriate.

BTW, I am also Steve S.

Steve S
PC Datasheet

 

[Guest]

Manythanks for your help. This is the way I was actually thinking of going
next but still too masny matches. Looks like I may have to go back to the
people who supply me the data from the Big Electronic monsters and get
something more specific to work from.

Again, many thanks

BTW, you have a Merry Christmas and a Happy New Year!!! What ever you do
have a safe one also.

The best you can do is create two queries; one for each table. Put the
following expression in an empty field:
LettersToMatch:Left([CustomerName],4)
Now create a third query that includes both the first two queries. Join the
two queries on LettersToMatch. You'll now get all records where the first
four letters of the customer name is in both tables.

Note: Change the 4 to whatever you think is appropriate.

BTW, I am also Steve S.

Steve S
PC Datasheet

Tanks for that now how can I refine it to return possible matches allowing
for variations on spelling, etc; Say customers name is Velkovski, yet in the
frads data it is spelt Velkovska J. How can I tweak the query to return these
possible matches??