Query that find duplicate records in a column

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

Guest

I have column licenseNo, it want to find out the duplicate values in that
column, please help me out
 
Abdul,

In the database window, click on queries on the left (or tab on the top,
if still on A97) and click on New in the toolbar. One of the options in
the pop-up window is Find Duplicates Wizard; select it and follow the
instructions.

HTH,
Nikos
 
1. Create a query into this table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Drag the LicenseNo field into the grid.
Accept Group By in the Total row under this field.

4. Drag the primary key field into the grid.
In the Total row under this field, choose Count.
In the Criteria row, enter:
1
Click to expand...

The query will show you the licence numbers where there's more than one.

Optional:
5. Drag the primary key into the grid again.
Choose Min in the Total row.

6. Drag the primary key into the grid again.
Choose Max in the Total row.

This shows you the lowest and highest primary key values of the duplicates.
(There may be others as well.)
 
Back
Top