Unique Records

[Robin Chapple]

I have a membership database, maintained by others, which some times
includes duplicated email addresses for reasons that do not concern
me.

I need to extract the email addresses to send broadcast emails to our
members.

I have a routine which extracts the primary email address from the
database, and then appends the secondary email address to make an
email address list table. This is achieved by using queries.

How do I eliminate duplicates in the easiest way?

Thanks,

Robin Chapple

 

[John Vinson]

How do I eliminate duplicates in the easiest way?

View the query's Properties, and set its Unique Values property to
True.

John W. Vinson[MVP]

 

[Robin Chapple]

My apology. As too often happens I did not explain myself properly.

The routine takes the email address from the member database appends
the alternative address from the member database to make a table that
is both addresses combined.

Now I need to be left with unique addresses in the easiest way.

Thanks,

Robin Chapple

 

[John Vinson]

My apology. As too often happens I did not explain myself properly.

The routine takes the email address from the member database appends
the alternative address from the member database to make a table that
is both addresses combined.

Now I need to be left with unique addresses in the easiest way.

Please post the SQL view of this query. Since I don't have any idea
how the query is structured or what it contains, it's a bit difficult
to give advice! Is its Unique property set? Does it contain fields
other than the email address? If you have two email addresses for the
same person, how can you determine which one to use?

John W. Vinson[MVP]

 

[Robin Chapple]

I am using three queries.

First to delete the existing records from the table.

The second to append primary email addresses.

The third to append secondary email addresses.

The database has only one field.

I have set the property to " No duplicates " which seems to achieve
the object. Is this an acceptable answer?

Duplication of addresses occurs for a variety of reasons which are
beyond my control. I just need unique addresses.

Thanks,

Robin Chapple

 

[John Vinson]

I have set the property to " No duplicates " which seems to achieve
the object. Is this an acceptable answer?

Sure. It's working then? You have no further difficulties?

John W. Vinson[MVP]

 

[Robin Chapple]

Yes John,

If that is an acceptable method.

Thanks,

Robin