Hi,

I've been struggling with a query in Access 97 and wonder if someone can
point me in the right direction.

I have a customers table and the fields I need in the query results are
customer name, postal address & email address.  There are a number of records
in the results that have a duplicate email address but the other information
is different (some address are duplicated 12 times or more - i.e. generic
email addresses rather than those to individuals)

What I want to achieve is to include just the first instance of the email
address - doesn't matter which customer name/address it returns - and exclude
the others.  Using "select distinct" won't work as the records are all unique
(it's only email address that's different)

Any guidance would be much appreciated.
Thanks.