Duplication Query

[Dz0n&]

My english is bad, sorry.

I want to make query to show double entries in field "1" which have
first 7 letters the same.

I'm using this query:

SELECT par.naziv_para, par.sifra, par.datum, par.vrijeme
FROM par
WHERE (((par.naziv_para) In (SELECT [naziv_para] FROM [par] As Tmp
GROUP BY [naziv_para],left([naziv_para],7) HAVING
Left([naziv_para],7) =Left([par].[naziv_para],7) and Count(*)>1 )))
ORDER BY par.naziv_para;

but that query dont work

please help

 

[Douglas J Steele]

Try:

SELECT par.naziv_para, par.sifra, par.datum, par.vrijeme
FROM par
INNER JOIN
(SELECT Left([naziv_para],7) AS ToMatch
FROM [par]
GROUP BY Left([naziv_para],7)
HAVING Count(*) >1) AS Tmp
ON Left(par.[naziv_para],7) = Tmp.ToMatch
ORDER BY par.naziv_para;