In (SELECT [FicheNo] FROM [PURCHINVOICELINES] As Tmp GROUP BY [FicheNo],[Amount] HAVING Count(*)>1 And [Amount] = [PURCHINVOICELINES].[Amount])
ibaresi mevcut.Ölçütün başına Not yazarak deneyebilir misiniz? Yani
Not In (SELECT [FicheNo] FROM [PURCHINVOICELINES] As Tmp GROUP BY [FicheNo],[Amount] HAVING Count(*)>1 And [Amount] = [PURCHINVOICELINES].[Amount])
olacak.