Help with find Duplicat records

[briansdell]

Help I have a table that contains 50700 records, one of the fieds (Folder ID)contains a duplicat record that is preventing me from setting that field to not except any duplicates. Can someone tell me is there a way to search the field for any 2 or more records that match? The problem I have is I don't know what files they are so I don't have anything to base the search on. I was hoping that I could enter some sort of wild card that would compare the files and report those that match.

Thanks

Brian

 

[PHV]

Something like this ?
SELECT [Folder ID], Count(*)
FROM theTable
GROUP BY [Folder ID]
HAVING Count(*)>1

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[briansdell]

Thanks but not sure I under stand do you run this from a Querie for from some other place.

Thanks

Brian

 

[PHV]

Copy the above SQL instruction and paste in the SQL view pane of a query window.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[briansdell]

sorry I should have told you I am not use SQL this likely explains why I can't find the view pane.
Any other Ideas??

Brian

 

[briansdell]

Thanks I got!