G
Guest
I have a table with the following fields:
ID# Fax# Contact Name
And I've created Query to find Duplicates from the Fax# field:
SELECT MyTable.ID#, MyTable.Fax#, MyTable.Contact_Name
FROM MyTable
WHERE (((MyTable.Fax#) In (SELECT [Fax#] FROM [MyTable] As Tmp GROUP BY
[Fax#] HAVING Count(*)>1 )) AND ((MyTable.Fax#)<>"") AND
((MyTable.Contact_Name) Is Not Null))
ORDER BY MyTable.Fax#;
Is it possible to then select all instances of the duplicate Fax# where
Contact_Name is not duplicated?
Many thanks,
ID# Fax# Contact Name
And I've created Query to find Duplicates from the Fax# field:
SELECT MyTable.ID#, MyTable.Fax#, MyTable.Contact_Name
FROM MyTable
WHERE (((MyTable.Fax#) In (SELECT [Fax#] FROM [MyTable] As Tmp GROUP BY
[Fax#] HAVING Count(*)>1 )) AND ((MyTable.Fax#)<>"") AND
((MyTable.Contact_Name) Is Not Null))
ORDER BY MyTable.Fax#;
Is it possible to then select all instances of the duplicate Fax# where
Contact_Name is not duplicated?
Many thanks,