Catching Duplicates

[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

 

[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