How to delete the duplicated records in a field?

[jamal numan]

How to delete the duplicated records in a field?



please, see the attached screen shot that shows my question

Sure, i can find the duplicated values in certain field but what i wanted is to delete these duplicated values!

is there away to delete these duplicated values in simple way?

regards

Jamal

[Robeen]

If you are able to create a query that FINDS the duplicate values you want to get rid of, then, once you have the query - convert the query to a Delete Query.
There should be a button in your query window with a X! & 'Delete'.
Once it is a Delete query - it will delete all the duplicates when you run it.

Hope this helps!

[jamal numan]

If you are able to create a query that FINDS the duplicate values you want to get rid of, then, once you have the query - convert the query to a Delete Query.
There should be a button in your query window with a X! & 'Delete'.
Once it is a Delete query - it will delete all the duplicates when you run it.

Hope this helps!

Thank you for the reply Robeen.

i tried to convert the query that specifies the duplicate values into "Delete query" but this action will delete 952 values from the source table! in other words, it will not delete ONLY the duplicate values from the source field

what might be the problem (the screen shots and the data are attached)?

regards

Jamal

[Robeen]

Did you 'Find Duplicates' query find all your duplicate rows?

I thought I might have given you wrong information so i just tested what I told you to do.

I added a two duplicate records to one of my tables.
Now I have three identical records.

I usd the query wizard to create a FindDuplicates query.
The query found all three duplicate records.

When I converted it to a Delete query and ran it, it wanted to delete all three of the identical records.

I can see right off the bat that I wouldn't necessarily want to delete all three - just two of the three.

Is that what you need as well?

[jamal numan]

Did you 'Find Duplicates' query find all your duplicate rows?

I thought I might have given you wrong information so i just tested what I told you to do.

I added a two duplicate records to one of my tables.
Now I have three identical records.

I usd the query wizard to create a FindDuplicates query.
The query found all three duplicate records.

When I converted it to a Delete query and ran it, it wanted to delete all three of the identical records.

I can see right off the bat that I wouldn't necessarily want to delete all three - just two of the three.

Is that what you need as well?

Sorry for the confusion.
please, refer to the first screen shot that shows what i have as source table (table10) that contains duplicates and the result that i wish to reach (table11).

i tried the method that you have described but sounds to delete all the records of the source table

what might be the problem?

regards

Jamal

[Robeen]

Looking at your screenshot1:

Create a query with SQL like this:
1. Start Query Design.
2. Do not select any table - click 'Close'.
3. On the top left - click 'SQL View'.
4. Type this in there: Select Distinct [Field1] From Table10.
5. Run the query.

Does that give you what you want?

[jamal numan]

Looking at your screenshot1:

Create a query with SQL like this:
1. Start Query Design.
2. Do not select any table - click 'Close'.
3. On the top left - click 'SQL View'.
4. Type this in there: Select Distinct [Field1] From Table10.
5. Run the query.

Does that give you what you want?

Perfect! this is what I'm looking for

Appreciated

Regards

Jamal

[Robeen]

Happy to help!!