unique only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tammy - 21 Sep 2007 23:42 GMT

Hello - I have a table of email addresses - I only want to see unique ones,
not duplicates.

Can someone please tell me how to set up the query??

Many thanks!

Reply to this Message

Jeff Boyce - 21 Sep 2007 23:50 GMT

Tammy

Open a new query in design view.

Add the table, add the email address field.

Right-click in the open/grey space above the grid... select Properties.

Change the Unique Values property to Yes.

Run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Hello - I have a table of email addresses - I only want to see unique
> ones,
[quoted text clipped - 3 lines]
>
> Many thanks!

Reply to this Message

Tammy - 22 Sep 2007 00:02 GMT

Thank you! It worked perfectly.

> Tammy
>
[quoted text clipped - 20 lines]
> >
> > Many thanks!

Reply to this Message