Mottah
Last Activity: Mar 25 '11, 01:28 PM
Joined: Mar 23 '11
Location:
-
Thank you Neopa. I guess I did not ask my question clearly in the beginning, but now everything works perfectly! -
I found the help I needed. I had to remove the date from the query when doing DISTINCT. Because all i was really looking for was non repetitive emails no matter the date. Thanx!
But I have another question, now that I have gotten the email addresses without duplicates. I want to use the results (the unique email addresses) to group them by location.
I have another column in my table called location.
What query...Leave a comment:
-
1. Each output record is a ticket sale (made up of date and email address)
2. I need to discard repetitive dates for the same email address
3. An email address appears more than once if it's owner made more than one sale.
4. Attempt to clarify question.
NB: I tried using the code with DISTINCT you recommended, but realised it can still include duplicates. If the same email address buys on different dates.Leave a comment:
-
What I have is a list of buyers who buy tickets online once or many times on different dates. The system tracks the date of purchase against the email address. If the same email address buys on different days it is tracked as another sale. What I want to extract from my database now is the email address, no matter how many they bought on different dates.Leave a comment:
-
How to Lose Duplicates in Query
This code works fine without the GROUP BY, as soon as i type it in and run the code access gives me an error msg: You tried to execute a query that does not include the specified expression 'date' as part of an aggregate function. But i need the group by to get rid of any duplicate email addresses. How can I tackle this?
...Code:SELECT emails.date, emails.email FROM emails WHERE emails.date<#11/1/2010# GROUP BY emails.email
No activity results to display
Leave a comment: