remove/hide double values from query result

[frankmanl]

My query finds records from a set of 3 connected tables (see image below).


The first table Adressen is the main table containing names, addresses etc. that I need, depending on values in the third table.
Some records from Adressen show up several times in the query result, because they have several references in the last table.
(I set the query's settings to Unique values: YES but that does not help, because of these values in the last table ...)

How can I arrange that the query only displays unique records from Adressen?
Table Adressen has a primary key which I might use, but I don't understand how I could do that.

Frank

[June7]

Build a report and use Sorting & Grouping features.

Or maybe use http://allenbrowne.com/func-concat.html

[xps35]

Do you need to show the values from the third table? If not, just use them as criterion but do not show them.

[frankmanl]

Really, is it that simple?
Thanks a lot, this solves my problem.
Frank

[ArviLaanemets]

Another solution will be something like (on fly)

SELECT adr.* FROM Addresser adr WHERE adr.AddressenID
IN((SELECT am.AddressenID FRoM [jointtbl_Addressen_Med...] am INNER JOIN [tblMedewerkers_Betro...] mb ON mb.BetrokkenID = am.ref_BetrokkenID WHERE am.Betrokenesoort = ?))