Wizard Duplicated record Query

[GetReel]

Hi

Ive have used the wizard to search for duplicate record. after running the query i noticed that it picks up records where there is more than to duplicated. There a some record where there a 3 or 4 records I need to keep.

The criteria in the query is as follows;
In (SELECT [Name] FROM [Table1] As Tmp GROUP BY [Name] HAVING Count(*)>1 )

I would to be able to have the query return results where there only 2 duplicates not 3 or more.

I tried using In (SELECT [Name] FROM [Table1] As Tmp GROUP BY [Name] HAVING Count(*)>1 and <3 ) but it doesnt work

 

[pbaldy]

Try this

=2

 

[GetReel]

WORKED!!!!!!!!!


Cheers ..!