When I do a duplicate query in Access using the ID field it is showing the ones below as duplicates and I don't want them to be shown as duplicates.
0013h00000HFbsa and 0013h00000HFbsA
The "A" on the end one is upper case and one is lower case. They should not be duplicates. I have a lot of these.
Here is the SQL View:
SELECT TestTable.[AccountID], TestTable.[GMID], TestTable.[ContactID], TestTable.[Customer Name]
FROM TestTable
WHERE (((TestTable.[AccountID]) In (SELECT [AccountID] FROM [TestTable] As Tmp GROUP BY [AccountID] HAVING Count(*)>1 )))
ORDER BY TestTable.[AccountID];