Problem with selection query

[Tourniquet]

After searching the forum for my problem, i couldn't find an answer.

I do have the following problem.

I created a query for printing a report. I would like to print the data of the current data that is shown in a record. I made a query named beknopt_overzicht. Data has to be sorted by pand_id.

I created first a few query's from the different tables i need for the report. Out of this query's i created the query beknopt_overzicht.

I also created a macro for opening the report, with the following WHERE statement : [Forms]![frm_pand_invoeren]![pand_id]=[pand_beknopt]![pand_id]

The only problem is, that it shows pand_id 4 times per id. So instead of 3 results, i have 12 results. I tried to use DISTINCT and DISTINCT ROW, but it doesn't work !!

is there any solution to solve this problem ??

My SQL-code of the query looks like this :

SELECT DISTINCT pand_overzicht.*, huurcontr_overzicht.*, gefact_overzicht.*, eigenaar_overzicht.*, jaarhuur.*
FROM eigenaar_overzicht, gefact_overzicht, huurcontr_overzicht, jaarhuur, pand_overzicht;


the funny part is that the other earlier created query's are selecting the way it should be. Just 3 results and not 12 !!
But the final query shows 12 results.

I hope you all will and can help

( forgive me for bad English though )

 

[Tourniquet]

I created the 'links' as you can see in the attachment.

The only prob now is that it again, only shows pand_id 1 four times.

I'm really getting frustrated !!

PLEASE HELP !


I made the following connections

pand-id - huurcontr_pand_id
gefact_id - huurcontr_gefact_id
eig_id - pand_eigenaarid