Ditinct query

[Dan]

Hi,
I have just one Access table with a lot of e-mails (more than 3000) sorted
in one column. There are some duplicated and I'd like to sort query with
unique e-mail (in new querie). As I can see command Distinct maybe can help
me, but I'm not so familiar with Access... Please help me.

Thnx!

 

[Dan]

Hi,
I have just one Access table with a lot of e-mails (more than 3000) sorted
in one column. There are some duplicated and I'd like to sort query with
unique e-mail (in new querie). As I can see command Distinct maybe can
help me, but I'm not so familiar with Access... Please help me.

Thnx!

Wrong subject: DISTINCT.

 

[Japie Botha]

This is quite east Your SQL statement would look something like the
following:

SELECT DISTINCT * FROM [your table name];
Hope this helps

 

[Dan]

This is quite east Your SQL statement would look something like the
following:

SELECT DISTINCT * FROM [your table name];
Hope this helps

Hm, it doesn't work.

Table with one column and data in rows:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

I'd like to create query and as result:
(e-mail address removed)
(e-mail address removed)

Could you help again? Many thanks!

 

[Pieter Wijnen]

select distinct * from atable rarely helps

select distinct oneormorefields from atable
does

pieter

This is quite east Your SQL statement would look something like the
following:

SELECT DISTINCT * FROM [your table name];
Hope this helps

Hm, it doesn't work.

Table with one column and data in rows:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

I'd like to create query and as result:
(e-mail address removed)
(e-mail address removed)

Could you help again? Many thanks!

 

[Dan]

"Pieter Wijnen"

select distinct * from atable rarely helps

select distinct oneormorefields from atable
does

http://www.databasedev.co.uk/eliminate_duplicates.html
this is helped.