Related Topics

Query Is Showing Duplicates

Duplicate records not showing on report
I have created a report from a query. There are duplicate last names in the table (which is just fine). E.g., I have 2 "Hogan"s and they are different persons and I want them both to show up on the report.

My query produces the correct result showing the duplicates but the report only shows 1 of the duplicates. I'm grouping on the last name (PrimaryLastName). What is the reportdoing to my duplicate records from the query? How do I fix that?


Duplicate records not showing on report
I have created a report from a query. There are duplicate last names in the table (which is just fine). E.g., I have 2 "Hogan"s and they are different persons and I want them both to show up on the report.

My query produces the correct result showing the duplicates but the report only shows 1 of the duplicates. I'm grouping on the last name (PrimaryLastName). Whatis the report doing to my duplicate records from the query? How do I fix that?


Create Query With Unique Records
I have a query that is showing records from a table that has many duplicate records. How can I refine the query to only show unique records? There are records that are close to duplicates,but in order to be duplicates they have to have the same data in more than 1 field (9 fields).


Duplicate showing in query when there shouldn't be
I have 1 query that is pulling from 3 tables. In those tables there aren't any duplicate entry's yet in the query I get duplicates for some entries. I can find no correlation as to why it could be choosing these as duplicates.


Deleting Duplicates
A Find Duplicates query has yielded over 7,000 records, and I need to get rid of the duplicates. My delete query ends up deleting both copies of the record


Eliminate duplicates
When I run a query with two tables I get duplicates
These are two tables of data from the same stores but different amounts of data for each causing duplicates I need to get rid of the duplicates for the report


Getting duplicates in query, but no duplicates in the tables
I have written a query based on 5 tables all in all, none of them have duplicate entries but when I link them together and display some fields I end up with some duplicates in the output. I have some calculated fields not sure if that makes any difference.


Getting rid of duplicates
This is my current query which creates duplicates.
How could it be improved?
Btw I m not allowed to create a query in design wizard. I have to do it in a written query.


Access - 68,000 rows max
I have a file with around 350,000 rows, of those around 80,000 are showing as duplicates. I was able to find the duplicates using a query, but when I tried to export to Excel (in .xlsx) it allowed a maximum of 68,000 rows.

I will freely admit that this was the first time I used Access, so I could be missing something really easy,

I am using Office 2010.

The original document is in either .csv or .xlsx, I tried it with both.


Showing Duplicates in table
Can anyone explain to me how to show Duplicates in a table or filter to show them. I need to clean up the table that was imported and it has over 2500 lines


Create a Find Duplicates Query
Use a Find Duplicates query to discover whether your tables contain duplicate records. With the wizard, creating the query is just a matter of answering some questions. These instructions apply to Access 97.


Find Duplicates Query
Does anyone know if there is a way to modify the find duplicates query so it will delete the duplicates while keeping the original record.

Say if I have a table that has 3 identical records I want to delete 2 of the 3 records


Deleting duplicate Records
I have a database with around 100,000 records however many of them are duplicates. I know which ones are duplicates now after doing a query. Is there anyway I can delete the duplicates off my Database


Remove Duplicates
How do I remove duplicates so that they do not show up in my Query?

When creating a Query, some of the regions come back to me more than once if the region has dual currency. I would like to only get each region name back once and avoid having to remove the duplicates after


Delete a record using a query
This is probably something relatively simple - but aI cannot figure out -or find a solution after searching.

I need to allow users sometimes to be able to delete a record using a query. The reason being - they request a query to show the data that they have entered that day to 'double check' that they have not missed any entries, made errors or that they have not entered duplicates that week.

The query is based on a date range and is a command button on a form. They would like to be able to delete the duplicates from that query at that time.

I know that there is a 'duplicates' query -but I would rather not automatically delete or hide their data.

I have created queries that do allow this - but I don't know why my queries allow it sometimes and sometimes they do not. The one that I created today does not allow deletions or edits.


Query Duplicates- Access 2003
I have about 52k of records with duplicates.

It is a list of names with SSN. Where there are two names with the same SSN and name, one my have a middle initial and one without one, or any combination with the Initial. I would prefer the one that does have the Initial, but then also get one of the duplicates that does not have this criteria to consider for the next record comparison.


Eliminating Duplicates from the Query Results
What I am trying to do is eliminate duplicates from the query results. I don't want to delete the record from the table, just have the query reflect only one record, not both.


Find Duplicates Query - Excluding Items
I'm working on some queries to help identify duplicates within a set of data we've got (invoices) and this query is great. The only issue I'm coming across is when I use the queryfor different types of checks, I don't have a way within the query to exclude duplicate checks.

For example, my first query looks for duplicates where the invoice number, invoice date, invoice amount, and vendor ID exactly match. The second query is where the vendor ID, invoice date,and invoice amount exactly match, but the invoice number is just similar.

Problem is, all the items that show on the first query are also going to show on the second query, along with the new items.


Delete Duplicate Records From Access Tables
Yes, deleting duplicates should be easy, but it's not. A Google search for newsgroup posts about deleting duplicates scored over 2500 hits. Clearly, this is a common problem.
The confusion is compounded, no doubt, by the existence of the built-in Find Duplicates query wizard. While this wizard does a great job of helping you identify duplicates, it does not provide a way to delete them. Many posts at the newsgroup included frustrated comments like this: "I can see them, but I can't delete them!"


DELETE Query for DUPLICATEs
I am trying to find the best method for removing duplicates in a table using a DELETE QUERY.

Keep in my that the table has thousands of records.

Some methods I have tried takes to Long and Hangs the DB