Need query to find potential duplicate names

[livewiremce]

Hello,

I need help to modify a query in MS Access 2010 - I need to find duplicates in [FIELD NAME] where they start with the same 5 letters. I created a regular "find duplicates query" but then I cannot figure out how to modify to make it locate ALL the entries that START with the same 5 characters.

In (SELECT [Field Name] FROM [TABLE] As Tmp GROUP BY [Field Name] HAVING Count(*)>1 )

[NeoPa]

It looks like you just need a little bit more in your SQL LiveWire. try out :

SELECT   [Field Name]
FROM     [Table]
WHERE    Left([Field Name],5) In (
    SELECT   Left([Field Name],5)
    FROM     [Table]
    GROUP BY Left([Field Name],5)
    HAVING   Count(*)>1)

[livewiremce]

It worked like a charm. Thanks!

[NeoPa]

I'm pleased it worked. The real question is whether or not it makes sense to you. If not then we should work on that ;-)

[livewiremce]

It totally does - I am relatively new to this kind of stuff so i could not figure out the syntax. Thanks for your help!