Hi !

In doing customerlist based on query. In query, i have only one line per customer, as it should be.

But, in report, i get random amounts of lines of same customer. Example:

Johns Carparts 044-5224821 Carstereet 12
Johns Carparts 044-5224821 Carstereet 12
Johns Carparts 044-5224821 Carstereet 12
Dinas Flowers 044-523787 Flowerstreet 11

How do i remove those extra Johns ? I only want one line per customer.
If i use Hide Duplicates from field, i get rid of extras. But, i get blank lines instead.

So, I need to get rid of the duplicates or the blank lines.

Thnx about ur help ppl !

Post the sql of your query
or
Check yourself by removing each table and join one by one which one is responsible for this problem

Hi !

Thanks for helping me out. Its been like 4 yrs that i havnt even thought about Access, so it may be something really simple. Here is the SQL:

SELECT Asiakkaat.Asno, Asiakkaat.Asiakas, Asiakkaat.Osoite, Asiakkaat.[Posti nro], Asiakkaat.Puh, Asiakkaat.IKuorma, Asiakkaat.IIKuorma, Kuljettajat.LähtöaikaI, Kuljettajat.LähtöaikaII
FROM Asiakkaat RIGHT JOIN Kuljettajat ON (Asiakkaat.IKuorma = Kuljettajat.IKuorma) AND (Asiakkaat.IIKuorma = Kuljettajat.IIKuorma)
WHERE (((Asiakkaat.Asno) Is Not Null));