Finding Duplicates Query

[CEB]

Hi Folks,
I have a quick question...probably with my logic. I have 20,000 records in a query. I know that some of the records are duplicates because I have the names, for example, FirstName:"Fred", LastName:"Flintstone" and then another record with FirstName:"Flintstone" , LastName:"Fred". I would like to find these records in another query. Now, my WHERE code in the SQL is
____________________________________________________________
WHERE ([Quick Query].[LastName] & [Quick Query].[FirstName])=([Quick Query].[FirstName] & [Quick Query].[LastName]);
____________________________________________________________
This returns all FirstName:"Fred", LastNAme:"Fred", but not what I want.
WHen I say it in English it seems to make sense:
WHERE FirstName AND LastNAME is Equal to LastName and FirstName.??
ANy thoughts are much appreciated.
Thanks,
Colin.

 

[Len Boorman]

Thinking out loud so stay with me
Create a query selecting First name and last name called query 1

create new query and add query 1 to grid TWICE

Link first name query 1 to last name query 1.1
Link Last name query 1 to first name query 1.1

links are both normal links i.e select matched records

select first name and last name from each query as output fields

Haven't tried it but just thinking

Len

 

[CEB]

Thank you Len, that worked out fine for me. It turns out that there are over 5000 dups!!
Thanks again,
Colin