livewiremce
Last Activity: Dec 19 '12, 06:54 PM
Joined: Dec 19 '12
Location:
-
It totally does - I am relatively new to this kind of stuff so i could not figure out the syntax. Thanks for your help! -
It worked like a charm. Thanks!Leave a comment:
-
Need query to find potential duplicate names
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.
Code:In (SELECT [Field Name] FROM [TABLE] As Tmp GROUP BY [Field Name] HAVING Count(*)>1 )
No activity results to display
Leave a comment: