Duplicate records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I want to make a query that shows me all duplicate records. How can I make it? I want to correct the data that have almost 10,000 records. It is really take time if I delete one by one. I want to use the field name CASNO to make a query. for example
if CASNO is the same, list all records have the same CASNO in the database
Are there any suggestion that would help me?
Thank you
Le Tran
 
1. Create a query into your table.

2. Depress the Total button on the toobar.
Access adds a Total row to the grid.

3. Drag CasNo into the grid.
Accept "Group By" in the Total row.

4. Drag CasNo into the grid again.
This time, choose "Count" in the Total row.
In the Criteria row under this field, enter:
1
Click to expand...

The query shows all the CasNo values that occur more than once.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Le Tran said:
I want to make a query that shows me all duplicate records. How can I make
Click to expand...
it? I want to correct the data that have almost 10,000 records. It is really
take time if I delete one by one. I want to use the field name CASNO to make
a query. for example.
 
Back
Top