Here is what my table looks like.
Person Date Entry Person1 05-20-14 142 Person2 05-20-14 443 Person1 05-21-14 248 Person1 05-21-14 142
I need two things.
First the number of times a Person made an entry for the first time.
I tried doing it with these queries. But the problem is I need this information per day.
That is if I query for 05/21, I need to see output
142 wont be included because it already exists.
In my query, I am filtering by date already, so I am not sure how to go out and search in the rest of the dates values. Here is what I have.
SELECT PERSON, Count(distinct Entry) from [table] where date >= 05/21/2014 and date < 05/22/2014 group by person order by person.
This gives me
Both 248 and 142 are considered here. How do I look for 142 was an entry already made in previous dates. I am not very good at nested queries.
Thanks for looking.