query to include an entry only once (omit second occurance)

Originally Posted by emandel

I have a query which is giving me [first name] [last name] and [e-mail]
This is a Union Query and therefor some records are repeated. In addition some households have differant members wusing the same e-mail. How do I make a second query to show me all of the data from the first query but to OMIT the second entry when an e-mail is repeated?
Thak you!

Originally Posted by MikeTheBike

Hi
As I understand it, if all the fields selected in the query are IDENTICAL in two or more records of a Union query, then only one record is returned, unless you use the ALL keyword ??

MTB

Originally Posted by emandel

I am interested in it returning only one record even if it's only the e-mail that is identical. I only want to send one e-mail out even if there are 2 unique people listed sharing that e-mail. Thanx