Duplicate Records

[goslincm]

I am working with a table that has three fields which make up a unique record. These fields are being imported into Access from a Paradox program (where they are listed as individual fields, and none designated as primary keys.

CountyCode LocalUnitType LocalUnitCode

County codes range from number 1-95 to represent the various counties in the State. Local Unit Types have code between 1-3 representing cities, villages and townships, then local unit code is merely a three digit number to distinquish between the same county with several townships.

What I need to find a way to do is to compare records within this table to look for duplicates.

I do not know how to approach this??

 

[PHV]

Something like this ?
SELECT CountyCode, LocalUnitType, LocalUnitCode
FROM yourTable
GROUP BY CountyCode, LocalUnitType, LocalUnitCode
HAVING COUNT(*) > 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Munzie]

Sounds simple the way you put it. Thanks so much!!