Catching Duplicates

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

I have a table and I want to find duplicates based on email.
So here are 2 people with the same email address.

- Person 1
Email: (e-mail address removed)
Group: CAPW03

- Person 2
Email: (e-mail address removed)
Group: CAPR03

and i want to keep the person that is in group CAPR03.
How would i go about doing this in Access.

Thanks.
Thomas
 
Hey Terry,

I still don;t have an answer to my question, but for you, if all you
need is to keep only one record then you can group by a certain field
and then set very other filed to first. So it looks like this.

Select First(id), First(name), First(number) From Table Group By sex
Order By Name

HTH,
Thomas
 
Back
Top