Exclude duplicate fields in query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Steve said:
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.
Click to expand...

Hi Steve,

Try to group your query and try to select as a group-function the
"select first" of your E-mail-Adress-Field
 
Back
Top