Finding 'duplicate' records

  • Thread starter Thread starter Rufus DeDufus
  • Start date Start date
R

Rufus DeDufus

I have a database containing a table "Files", with fields "ID" (autonumber),
"size", and "checksum", and others which will not concern us.

I wish to know the IDs of the records that have duplicates. A duplicate is
defined as a record which has the same Size and the same Checksum as at
least one other record in the database (ID is always unique).

Example:

FILES
-------------------------------------------------------------------
ID Size Checksum
1 100 1234
2 200 8899
3 100 1234
4 201 8899

Would return IDs 1, 3 as identical. If there are more than one set of
identical files, it is not required that they be organized into sets, e.g.:

FILES
-------------------------------------------------------------------
ID Size Checksum
1 100 1234
2 200 8899
3 300 3333
4 100 1234
5 299 3333
6 300 3333

.... would return (1 = 4) and (3 = 6) as duplicates, but I can take an answer
of (1, 3, 4, 6).


How do I query for this?
It is easy enough to query for all files (if any) matching record ID 'n'.
That is not requested - I know how to do that.

I am using Access 2000.

Reply to efowler <at> seanet <dot> com.


Thanks very much.

Eric
 
Hi Rufus,

Just use the Find Duplicates query wizard. You can get to this from the
New button in the query pane of the database windows, or with the
Insert|Query menu command.
 
Back
Top