Sean Meyer
asked on
Access -- Filter out duplicates
Access 2010 - Here is what I am doing ---
Fields -
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?
Fields -
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Add the Totals button to your query design and it removes duplicates.
It will add the row "Total:" to your query design and each item will show "Group By"
Thank you!