Multiple instances

  • Thread starter Thread starter Exaviour
  • Start date Start date
E

Exaviour

I have a table were one field may have multiple instances of the same # , I
would like to query that field and only show items with duplicates.

Any help would be appreciated
Thanks
 
If you just want to show the duplicates in the one field,
create a new query, select that field twice. Click on the
totals button. Leave the first as group by. Change the
second to count. In criteria for the second, enter >1
This will give you the numbers in that field where there
is more than 1 occurrence.
 
To get the duplicated items:
1. Create a query into this table.

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

3. Drag your # field into the grid.
Accept Group By in the Total row.

4. Drag the primary key field into the grid.
In the Total row, choose Count.
In the Criteria row, enter: >1

This query displays the numbers that have duplicates.

To see all details of each of the duplicates, save the query, and then use
it as an input table for anther query, along with your table, joined on the
# field.
 
Thanks Allen, Les worked great I had the "count" part down it was the detail
part that was giving me grief.
 
Back
Top