How can I identify if a record has two different records?

If the ID is unique then you should be able to identify the duplicates like this.

SELECT [IDField], Count([IDField])),
FROM [MyTable]
GROUP BY [IDField]
HAVING Count([IDField])>1