Zkus toto:
SELECT Tabulka.Polozka, Tabulka.Cena
FROM Tabulka
WHERE (((Tabulka.Polozka) In (SELECT [Polozka] FROM [Tabulka] As Tmp GROUP BY [Polozka] HAVING Count(*)>1 )));
Nezaručuji, ale možná to bude i fungovat.
Zkus toto:
SELECT Tabulka.Polozka, Tabulka.Cena
FROM Tabulka
WHERE (((Tabulka.Polozka) In (SELECT [Polozka] FROM [Tabulka] As Tmp GROUP BY [Polozka] HAVING Count(*)>1 )));
Nezaručuji, ale možná to bude i fungovat.