Поиск дублей

SELECT ID & "|" & Fam & "|" & [Name] & "|" & Otch AS groupFld, COUNT(*) AS kol
FROM Таблица
GROUP BY ID & "|" & Fam & "|" & [Name] & "|" & Otch
HAVING COUNT(*)>1

SELECT t1.ID, t1.Fam, t1.[Name], t1.Otch, COUNT(*) AS kol
FROM (SELECT DISTINCT ID, Fam, [Name], Otch FROM Таблица) t1 
  INNER JOIN Таблица t2 ON t1.ID=t2.ID AND t1.Fam=t2.Fam AND t1.[Name]=t2.[Name] AND t1.Otch=t2.Otch
GROUP BY t1.ID, t1.Fam, t1.[Name], t1.Otch
HAVING COUNT(*)>1
ORDER BY COUNT(*) DESC

SELECT t1.ID, t1.Fam, t1.[Name], t1.Otch INTO TempTable
FROM (SELECT DISTINCT ID, Fam, [Name], Otch FROM Таблица) t1 
  INNER JOIN Таблица t2 ON t1.ID=t2.ID AND t1.Fam=t2.Fam AND t1.[Name]=t2.[Name] AND t1.Otch=t2.Otch
GROUP BY t1.ID, t1.Fam, t1.[Name], t1.Otch
HAVING COUNT(*)>1

DELETE * 
FROM Таблица t1 
  INNER JOIN TempTable t2 ON t1.ID=t2.ID AND t1.Fam=t2.Fam AND t1.[Name]=t2.[Name] AND t1.Otch=t2.Otch

INSERT INTO Таблица (ID, Fam, [Name], Otch)
SELECT ID, Fam, [Name], Otch FROM TempTable

SELECT t1.ID,t1.Fam,t1.[Name],t1.Otch FROM Таблица t1 INNER JOIN  Таблица t2 ON  t1.Fam=t2.Fam AND t1.Name=t2.Name AND t1.Otch=t2.Otch
WHERE  t1.ID<>t2.ID