Hi,
i have different fields in access database which have data, which are identical in a sense, but due to wrong data entry in those fields, it is not getting extracted as duplicate entries with total count. Sample I have attached already below along with attachment with sample database containing fields:
sr.no. 1,3,4 in database being same record of one customer and sr. no. 2,6,7 also being same record of other customer. But due to error in punching in name, fathername, address field, basic queries are not picking it as multiple record of one and same customer.
I want to compare Ist record containing name, father name, address with next record containing same and then with next till the last record and output from access to be generated like as mentioned below. It is actually fuzzy matching
"wherever Ist record has >80% resemblance with any other record in database, query should generate all those records in order. Similary for 2nd record, it should compare with all other records and produce the output in query for records which has >80% resemblance. Sample records I have attached above for reference
For information, database is in access and has 16-17 lacs of records.
Access based vba code or sql query is highly appreciated
Can anyone help me in this regard in this forum.
Rgds
Nikhil
# Name Father Name Address
1 Mohd. Sulaiman Habba Kadal, rajouri
2 Ram Mohan Santosh Ram Nagar, Udhampur
3 Mohd. Sulaiman Habba Kadal, rajouri
4 Mohammad Sulaiman Habba Kadal, rajouri
5 Ramsharan Rupinder Talabtillo
6 Ram Santosh Ram Nagar, Udhampur
7 Ram Mohan Santosh RamNagarudhampur