Find Duplicates & wildcards?

[Amy]

I would like to find duplicate records. My fields with the same info are:
FirstName and LastName. The FirstName field may have a middle initial in it
but it is the same person. Is it possible to run a query to find duplicates
if the field is not exact?

Example:

John Doe
John P. Doe
John P Doe

Thanks,
Amy

 

[Mika Oukka]

Here is one idea. Make a query that will have a following field:



CleanName: IIf(InStr(1,[FirstName],"
",1)>0,Left([firstname],InStr(1,[FirstName]," ",1)-1),[firstname]) & " " &
[lastname]



that will convert the FistName and LastName to a one field in query
resulting



Clean Name

John Doe

John Doe

John Doe



after this in design view, choose View-Totals.



Hopefully this helps you to solve the problem



Mika Oukka