Access -- Filter out duplicates

Posted on 2013-09-18
Medium Priority
Last Modified: 2013-09-18
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?
Question by:Sean Meyer
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 39503174
have you tried using a total query?

Author Closing Comment

by:Sean Meyer
ID: 39503192
Figured it out and then found you had posted the correct answer.

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!

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question