[AccessD] query

Hello,

i have a query in which i want to show each "Praktijk" with the same "adres". 
How can this been done

now i get

[Praktijk]       [adres]
Janssen          rondweg
Janssen          rondweg
Janssen          rondweg
Janssen          herenweg
Hendriks         kortweg
Hendriks         kortweg
Hendriks         langeweg


i would like to have

[Praktijk]       [adres]
Janssen          rondweg
Janssen          herenweg
Hendriks         kortweg
Hendriks         langeweg


<sql>
SELECT DISTINCTROW tblHarts.Praktijk, tblHarts.Adres, tblHarts.Postcode, tblHarts.Plaats, tblHarts.Oud
FROM tblHarts
WHERE (((tblHarts.Praktijk) In (SELECT [Praktijk] FROM [tblHarts] As Tmp GROUP BY [Praktijk] )) AND ((tblHarts.Oud)=No))
ORDER BY tblHarts.Praktijk;
</sql>