Access 2010 - Here is what I am doing ---
A -- Person ID
B -- Location
C -- Date
D -- Person seen
E -- Items bought
Table contains 100,000 records. First I created a query to filter on location. Dropped results to 1,800. Problem I am having is that even though I only included columns A, B, C and D I am getting duplicate entries based on column E.
What I would like to do is only see each person ID once per day. What do I need to do in order to accomplish this feat?