Recent content by DocWebb

PREFECT! THANKS! This works; SELECT tablename.email, Min(tablename.firstname) AS MinOffirstname, Min(tablename.lastname) AS MinOflastname FROM tablename GROUP BY tablename.email HAVING (((tablename.email) Like "*@*" And (tablename.email) Not Like "* *" And (tablename.email) Not Like " *"))...

OOPS - IT IS NOT WORKING. STILL HAVE DUPLICATE EMAILS IN MY LIST! Doc

THANKS! THAT HELPED!!! This works; SELECT tablename.email, tablename.firstname, tablename.lastname, FROM tablename GROUP BY tablename.email, tablename.firstname, tablename.lastname, HAVING (((tablename.email) Is Not Null)); Sorry I forgot to say I need first and last names too, that is why I...

I tried this to produce a list of UNIQUE email addresses out of our ms access db (tablename db fields include email, list and date): SELECT DISTINCT tablename.email, * FROM tablename WHERE (((tablename.email) Is Not Null) AND ((tablename.list) Like "yes")) ORDER BY tablename.date; BUT I am...

I tried this to produce a list of UNIQUE email addresses out of our ms access db (tablename db fields include email, list and date): SELECT DISTINCT tablename.email, * FROM tablename WHERE (((tablename.email) Is Not Null) AND ((tablename.list) Like "yes")) ORDER BY tablename.date; BUT I am...